text: CREATE TABLE invoices (total INTEGER, customer_id VARCHAR); CREATE TABLE customers (first_name VARCHAR, last_name VARCHAR, id VARCHAR) -- List the top 10 customers by total gross sales. List customers' first and last name and total gross sales. SELECT T1.first_name, T1.last_name, SUM(T2.total) FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id = T1.id GROUP BY T1.id ORDER BY SUM(T2.total) DESC LIMIT 10 CREATE TABLE tracks (genre_id VARCHAR); CREATE TABLE genres (name VARCHAR, id VARCHAR) -- List the top 5 genres by number of tracks. List genres name and total tracks. SELECT T1.name, COUNT(*) FROM genres AS T1 JOIN tracks AS T2 ON T2.genre_id = T1.id GROUP BY T1.id ORDER BY COUNT(*) DESC LIMIT 5 CREATE TABLE albums (title VARCHAR) -- List every album's title. SELECT title FROM albums CREATE TABLE albums (title VARCHAR) -- List every album ordered by album title in ascending order. SELECT title FROM albums ORDER BY title CREATE TABLE albums (title VARCHAR) -- List every album whose title starts with A in alphabetical order. SELECT title FROM albums WHERE title LIKE 'A%' ORDER BY title CREATE TABLE customers (first_name VARCHAR, last_name VARCHAR, id VARCHAR); CREATE TABLE invoices (customer_id VARCHAR) -- List the customers first and last name of 10 least expensive invoices. SELECT T1.first_name, T1.last_name FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id = T1.id ORDER BY total LIMIT 10