Question

PLEASE ANSWER IN MYSQL WORKBENCH
For each Invoice in the database list the InvoiceId, the InvoiceDate, the CustomerId, and Total. Also include the customer's LastName, and Country. Add a clause so that the result is sorted by country A-Z, and within each country by invoice total - largest to smallest.

Answer 1

/*creating table*/

CREATE DATABASE Invoice;

/*Use Database*/

USE Invoice.

/*creating table*/

CREATE TABLE Invoice(
-> Invoice_id INT NOT NULL AUTO_INCREMENT,
-> Customer_id INT NOT NULL AUTO_INCREMENT,
-> Customer_lastname VARCHAR(20) NOT NULL,
-> Country VARCHAR(40) NOT NULL,
-> Invoice_date DATE,
-> Total INT,
-> PRIMARY KEY ( Invoice_id )
-> );

/*query*/

select * from Invoice where Country IN(select Country, Total from Invoice GROUPBY Country ORDERBY Total DESC) oreder by Country ASC;