text: CREATE TABLE CUSTOMER (FirstName VARCHAR, LastName VARCHAR, Email VARCHAR) -- What is the first name and last name of the customer that has email "luisg@embraer.com.br"? SELECT FirstName, LastName FROM CUSTOMER WHERE Email = "luisg@embraer.com.br" CREATE TABLE CUSTOMER (Email VARCHAR) -- How many customers have email that contains "gmail.com"? SELECT COUNT(*) FROM CUSTOMER WHERE Email LIKE "%gmail.com%" CREATE TABLE CUSTOMER (SupportRepId VARCHAR, FirstName VARCHAR); CREATE TABLE EMPLOYEE (FirstName VARCHAR, LastName VARCHAR, EmployeeId VARCHAR) -- What is the first name and last name employee helps the customer with first name Leonie? SELECT T2.FirstName, T2.LastName FROM CUSTOMER AS T1 JOIN EMPLOYEE AS T2 ON T1.SupportRepId = T2.EmployeeId WHERE T1.FirstName = "Leonie" CREATE TABLE EMPLOYEE (City VARCHAR, EmployeeId VARCHAR); CREATE TABLE CUSTOMER (SupportRepId VARCHAR, PostalCode VARCHAR) -- What city does the employee who helps the customer with postal code 70174 live in? SELECT T2.City FROM CUSTOMER AS T1 JOIN EMPLOYEE AS T2 ON T1.SupportRepId = T2.EmployeeId WHERE T1.PostalCode = "70174" CREATE TABLE EMPLOYEE (city VARCHAR) -- How many distinct cities does the employees live in? SELECT COUNT(DISTINCT city) FROM EMPLOYEE CREATE TABLE CUSTOMER (CustomerId VARCHAR, FirstName VARCHAR); CREATE TABLE INVOICE (InvoiceDate VARCHAR, CustomerId VARCHAR) -- Find all invoice dates corresponding to customers with first name Astrid and last name Gruber. SELECT T2.InvoiceDate FROM CUSTOMER AS T1 JOIN INVOICE AS T2 ON T1.CustomerId = T2.CustomerId WHERE T1.FirstName = "Astrid" AND LastName = "Gruber"