text: CREATE TABLE phone (Memory_in_G VARCHAR, Carrier VARCHAR) -- What are the memories and carriers of phones? SELECT Memory_in_G, Carrier FROM phone CREATE TABLE phone (Carrier VARCHAR, Memory_in_G INTEGER) -- List the distinct carriers of phones with memories bigger than 32. SELECT DISTINCT Carrier FROM phone WHERE Memory_in_G > 32 CREATE TABLE phone (Name VARCHAR, Carrier VARCHAR) -- Show the names of phones with carrier either "Sprint" or "TMobile". SELECT Name FROM phone WHERE Carrier = "Sprint" OR Carrier = "TMobile" CREATE TABLE phone (Carrier VARCHAR, Price VARCHAR) -- What is the carrier of the most expensive phone? SELECT Carrier FROM phone ORDER BY Price DESC LIMIT 1 CREATE TABLE phone (Carrier VARCHAR) -- Show different carriers of phones together with the number of phones with each carrier. SELECT Carrier, COUNT(*) FROM phone GROUP BY Carrier CREATE TABLE phone (Carrier VARCHAR) -- Show the most frequently used carrier of the phones. SELECT Carrier FROM phone GROUP BY Carrier ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE phone (Carrier VARCHAR, Memory_in_G INTEGER) -- Show the carriers that have both phones with memory smaller than 32 and phones with memory bigger than 64. SELECT Carrier FROM phone WHERE Memory_in_G < 32 INTERSECT SELECT Carrier FROM phone WHERE Memory_in_G > 64 CREATE TABLE phone (Name VARCHAR, Phone_ID VARCHAR); CREATE TABLE market (District VARCHAR, Market_ID VARCHAR); CREATE TABLE phone_market (Market_ID VARCHAR, Phone_ID VARCHAR) -- Show the names of phones and the districts of markets they are on. SELECT T3.Name, T2.District FROM phone_market AS T1 JOIN market AS T2 ON T1.Market_ID = T2.Market_ID JOIN phone AS T3 ON T1.Phone_ID = T3.Phone_ID