1) Write SQL to return the first and last name of all actors with a first name of "ADAM" (use the ACTOR table)

2) Write SQL with the LIKE operator to return addresses that are in the "Dhaka" district and have street addresses that do not contain the character sequence "Loop". You can return all information from the ADDRESS table that matches this criteria.

3) Write SQL with the BETWEEN and ORDER BY clause to return the payments in descending order (i.e., highest payments first) from the PAYMENT table for customer IDs between 300 and 400.

4) Write SQL with the IN operator to return a concatenation of film title and description from the FILM table that have a replacement cost of either 10.99, 23.99, or 21.99 or have a description that contains the character sequence "Drama". Do NOT use the OR operator more than once in your solution. Your result should contain a single column and start like the following (HINT: you will need to use the CONCAT function)

ALABAMA DEVIL: A Thoughtful panorama of a database adm.....

ALI FOREVER: A Action-Packed Drama of a Dentist and a cro....

5) Write SQL with logical operators to return all information about payments in the PAYMENT table that were either (a) more than $3 and less or equal to than $8 OR (b) round to $1 (HINT: use the ROUND function)