text: CREATE TABLE employees (first_name VARCHAR, last_name VARCHAR, birth_date VARCHAR) -- Who is the youngest employee in the company? List employee's first and last name. SELECT first_name, last_name FROM employees ORDER BY birth_date DESC LIMIT 1 CREATE TABLE employees (first_name VARCHAR, last_name VARCHAR, hire_date VARCHAR) -- List top 10 employee work longest in the company. List employee's first and last name. SELECT first_name, last_name FROM employees ORDER BY hire_date LIMIT 10 CREATE TABLE employees (city VARCHAR, title VARCHAR) -- Find the number of employees whose title is IT Staff from each city? SELECT COUNT(*), city FROM employees WHERE title = 'IT Staff' GROUP BY city CREATE TABLE employees (first_name VARCHAR, last_name VARCHAR, id VARCHAR); CREATE TABLE employees (reports_to VARCHAR) -- Which employee manage most number of peoples? List employee's first and last name, and number of people report to that employee. SELECT T2.first_name, T2.last_name, COUNT(T1.reports_to) FROM employees AS T1 JOIN employees AS T2 ON T1.reports_to = T2.id GROUP BY T1.reports_to ORDER BY COUNT(T1.reports_to) DESC LIMIT 1 CREATE TABLE invoices (customer_id VARCHAR); CREATE TABLE customers (id VARCHAR, first_name VARCHAR, last_name VARCHAR) -- How many orders does Lucas Mancini has? SELECT COUNT(*) FROM customers AS T1 JOIN invoices AS T2 ON T1.id = T2.customer_id WHERE T1.first_name = "Lucas" AND T1.last_name = "Mancini"