help@plusacademics.org

1.       “XXX_Civiccenter_query.sql” where XXX are your initials. 

1.       “XXX_Civiccenter_query.sql” where XXX are your initials.  This is an SQL script which will run a query on your database and show the results.  Write SQL statement(s) which will produce an output table with the following fields in it, sorted with the most expensive tickets at the top, and then alphabetically by customer name:

 

Name

Opera

Cost

Date

Backstage Pass?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 



honeyd


12-09-20 | 15:45:33

use civiccenter;
select customer.idcustomer,customer.name, opera.OperaName,opera.OperaCost, opera.PerformanceDate,Backstage
FROM customer right JOIN opera
ON customer.idcustomer = opera.customer_idcustomer order by operacost desc, name asc;

Login to answer this question!