text: CREATE TABLE customers (company VARCHAR, first_name VARCHAR, last_name VARCHAR) -- Eduardo Martins is a customer at which company? SELECT company FROM customers WHERE first_name = "Eduardo" AND last_name = "Martins" CREATE TABLE customers (email VARCHAR, phone VARCHAR, first_name VARCHAR, last_name VARCHAR) -- What is Astrid Gruber's email and phone number? SELECT email, phone FROM customers WHERE first_name = "Astrid" AND last_name = "Gruber" CREATE TABLE customers (city VARCHAR) -- How many customers live in Prague city? SELECT COUNT(*) FROM customers WHERE city = "Prague" CREATE TABLE customers (state VARCHAR) -- How many customers in state of CA? SELECT COUNT(*) FROM customers WHERE state = "CA" CREATE TABLE customers (country VARCHAR, first_name VARCHAR, last_name VARCHAR) -- What country does Roberto Almeida live? SELECT country FROM customers WHERE first_name = "Roberto" AND last_name = "Almeida" CREATE TABLE artists (id VARCHAR, name VARCHAR); CREATE TABLE albums (title VARCHAR, artist_id VARCHAR) -- List the name of albums that are released by aritist whose name has 'Led' SELECT T2.title FROM artists AS T1 JOIN albums AS T2 ON T1.id = T2.artist_id WHERE T1.name LIKE '%Led%' CREATE TABLE employees (id VARCHAR, first_name VARCHAR, last_name VARCHAR); CREATE TABLE customers (support_rep_id VARCHAR) -- How many customers does Steve Johnson support? SELECT COUNT(*) FROM employees AS T1 JOIN customers AS T2 ON T2.support_rep_id = T1.id WHERE T1.first_name = "Steve" AND T1.last_name = "Johnson"