Question

Consider a table "MYPET" with the following data:

Table: MYPET
Pet_id	Pet_Name	Breed	LifeSpan	Price	Discount
101	Rocky	Labrador Retriver	12	16000	5
202	Duke	German Shepherd	13	22000	10
303	Oliver	Bulldog	10	18000	7
404	Cooper	Yorkshire Terrier	16	20000	12
505	Oscar	Shih Tzu	NULL	25000	8

Write SQL queries for the following:

1. Display the Breed of all the pets in uppercase.
2. Display the total price of all the pets.
3. Display the average life span of all the pets.

Answer 1

1. SELECT UPPER(Breed) FROM MYPET;
2. SELECT SUM(Price) FROM MYPET;
3. SELECT AVG(LifeSpan) FROM MYPET;