Question

set me given number is even or odd.
Consider the table Watches, and write the output of the following queries:
Table : Watches
Watchid Watch Name Price | Type Qty store
W001 High Time 10000 Unisex 100
W002 Life Time 15000 Ladies 150
W003 Wave
20000 Gents 200
W004 HighFashion 7000 Unisex 250
W005 Golden Time 25000 Gents 100
On the basis of the above table, find the output of the following queries :
(i) Select sum(Qty_store) from Watches where Type - Unisex';
(ii) Select count (distinct Type) from Watches;
(iii) Select * from Watches where Watch_Name in('Wave', 'Golden Time');
(iv) Select SUBSTR(Typo, 1,3) SUBTYPES" from Watches
where Qty_store> 150:​

Answer 1

Answer:

do not getting this question sorry

Answer 2

Answer:

i) 350

ii) 3

iii) It executes the watchid W003 and W005 including full row

iv) Gen

Uni