In SQL code please

This assignment again involves use of the PETS table

Using the PETS table that we added to this semester, write queries that will do the following:

1.Display the name, pet_type color, weight, and location of animals that fall into one of the following two categories:

a.Cats that weigh more than 70 pounds

b.Indoor Lizards

2.Display the name, pet_type and color of animals that fall into one of the following categories:

a.Turtles

b.Yellow pets

3.The weight of the animals have been recorded in pounds. Knowing that a kilogram is 2.2 pounds, write a query that contains the pet_name, weight in pounds (labeled as Lb), and weight in kilograms (labeled as Kg)

4.Display all pets' names in all capital letters, weight, and age in weeks (labeled as Age).

5.Display pet names, and birthdate in the following format: Month DD, YYYY as shown below:

6.Display one column for each pet labeled PET_DESC that reads as below:

7.Display each pet's name in all lowercase letters and an additional column labeled PET_INITIAL that contains the first initial of the pet's name

8.Display the name and weight of all cats, and a column called ADJUSTED_WEIGHT, that will adjust adjust weight up by 15%.

9.Display a list of the distinct pet colors in the PETS table.

10.Display a single column called PET_NARRATIVE that displays the pet's name, type, age and color as below:

R2 Actions COLUMN NAME NULLABLE DATA DEFAULTCOLUMN ID COMMENTS No DATA TYPE NUMBER (5,0) VARCHAR2 (30 BYTE) No VARCHAR2 (20 BYTE) No DATE 1PET ID 2 PET NAME 3 PET TYPE 4 PET DOB 5 PET WEIGHT NUMBER (5,0) 6 PET COLOR 7 PET_LOCATION VARCHAR2 (10 BYTE) No 8 PET DEATH (null) (null) (null) (null) (null) (null) (null) (null) l (null) 2 (null) 3 (null) 4 (null) 5 (null) 6 (null) 7 (null) 8 (null) No No VARCHAR2 (25 BYTE) No DATE No