Assessment Test #1.
/*COMPLETE THE FOLLOWING TASKS!*/
/* 1. Return the customer IDs of customers who have spent at least $110 with the staff member who has an ID of 2. The answer should be customers 187 and 148.*/
SELECT * FROM payment ;
SELECT customer_id, SUM(amount) FROM payment
WHERE staff_id = 2 GROUP BY customer_id
HAVING SUM(amount) >= 110;
/* 2. How many films begin with the letter J? The answer should be 20. */
SELECT * FROM film;
SELECT COUNT(*) FROM film
WHERE title LIKE 'J%';
/* 3. What customer has the highest customer ID number whose name starts with an 'E' and has an address ID lower than 500?*/
SELECT * FROM customer;
SELECT customer_id, first_name, last_name FROM customer
WHERE first_name LIKE 'E%' AND address_id < 500
ORDER BY customer_id DESC LIMIT 1;