text: CREATE TABLE happy_hour (shop_id VARCHAR) -- which shop has happy hour most frequently? List its id and number of happy hours. SELECT shop_id, COUNT(*) FROM happy_hour GROUP BY shop_id ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE happy_hour (MONTH VARCHAR) -- Which month has the most happy hours? SELECT MONTH FROM happy_hour GROUP BY MONTH ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE happy_hour (MONTH VARCHAR) -- Which months have more than 2 happy hours? SELECT MONTH FROM happy_hour GROUP BY MONTH HAVING COUNT(*) > 2 CREATE TABLE ALBUM (Id VARCHAR) -- How many albums are there? SELECT COUNT(*) FROM ALBUM CREATE TABLE GENRE (Name VARCHAR) -- List the names of all music genres. SELECT Name FROM GENRE CREATE TABLE CUSTOMER (State VARCHAR) -- Find all the customer information in state NY. SELECT * FROM CUSTOMER WHERE State = "NY" CREATE TABLE EMPLOYEE (FirstName VARCHAR, LastName VARCHAR, City VARCHAR) -- What are the first names and last names of the employees who live in Calgary city. SELECT FirstName, LastName FROM EMPLOYEE WHERE City = "Calgary" CREATE TABLE INVOICE (BillingCountry VARCHAR) -- What are the distinct billing countries of the invoices? SELECT DISTINCT (BillingCountry) FROM INVOICE CREATE TABLE ARTIST (Name VARCHAR) -- Find the names of all artists that have "a" in their names. SELECT Name FROM ARTIST WHERE Name LIKE "%a%" CREATE TABLE ARTIST (ArtistId VARCHAR, Name VARCHAR); CREATE TABLE ALBUM (ArtistId VARCHAR) -- Find the title of all the albums of the artist "AC/DC". SELECT Title FROM ALBUM AS T1 JOIN ARTIST AS T2 ON T1.ArtistId = T2.ArtistId WHERE T2.Name = "AC/DC"