text: CREATE TABLE invoices (total INTEGER, billing_city VARCHAR, billing_state VARCHAR) -- List total amount of invoice from Chicago, IL. SELECT SUM(total) FROM invoices WHERE billing_city = "Chicago" AND billing_state = "IL" CREATE TABLE invoices (billing_city VARCHAR, billing_state VARCHAR) -- List the number of invoices from Chicago, IL. SELECT COUNT(*) FROM invoices WHERE billing_city = "Chicago" AND billing_state = "IL" CREATE TABLE invoices (billing_state VARCHAR, billing_country VARCHAR) -- List the number of invoices from the US, grouped by state. SELECT billing_state, COUNT(*) FROM invoices WHERE billing_country = "USA" GROUP BY billing_state CREATE TABLE invoices (billing_state VARCHAR, billing_country VARCHAR) -- List the state in the US with the most invoices. SELECT billing_state, COUNT(*) FROM invoices WHERE billing_country = "USA" GROUP BY billing_state ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE invoices (billing_state VARCHAR, total INTEGER) -- List the number of invoices and the invoice total from California. SELECT billing_state, COUNT(*), SUM(total) FROM invoices WHERE billing_state = "CA" CREATE TABLE artists (id VARCHAR, name VARCHAR); CREATE TABLE albums (title VARCHAR, artist_id VARCHAR) -- List Aerosmith's albums. SELECT T1.title FROM albums AS T1 JOIN artists AS T2 ON T1.artist_id = T2.id WHERE T2.name = "Aerosmith" CREATE TABLE artists (id VARCHAR, name VARCHAR); CREATE TABLE albums (artist_id VARCHAR) -- How many albums does Billy Cobham has? SELECT COUNT(*) FROM albums AS T1 JOIN artists AS T2 ON T1.artist_id = T2.id WHERE T2.name = "Billy Cobham"