Ask a question?
customers' reviews
Need customized help? Order now
email

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?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 



Need customized help? Order now
user img

honeyd


12-09-20 | 10:45:33
Report this answer
(no reviews)

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;


Related Question