answer query code questions below

Methods and Tools in SW Development Homowork 2 Given the following database table, give the requested SQL query (not the results) that fulfils the prompt. Assume the table and column names are as listed (casing the same). 1. Return contacts with the first name "John" 2. Return the name and age of contacts ordered by age (oldest to youngest) 3. Return all the contacts 4. Return contacts with the last name "Brinkiey' 5. Return contacts between the ages of 20 and 30 (inclusive) 6. Return the name of the contacts that have the zp code of 39759 7. Update Corrissa Farm's age to 27 8. Insert another contact into the table (values are up to you) 9. Delete any contacts that live on a street containing "Poplar' anywhere in the address 10. Return a list of unique zip codes contained in the table