Question

Write the outputs of the SQL queries (i) to (iv) based on the relations COMPUTER and SALES given below:

Table: COMPUTER
PROD_ID	PROD_NAME	PRICE	COMPANY	TYPE
P001	MOUSE	200	LOGITECH	INPUT
P002	LASER PRINTER	4000	CANON	OUTPUT
P003	KEYBOARD	500	LOGITECH	INPUT
P004	JOYSTICK	1000	IBALL	INPUT
P005	SPEAKER	1200	CREATIVE	OUTPUT
P006	DESKET PRINTER	4300	CANON	OUTPUT

Table: SALES
PROD_ID	QTY_SOLD	QUARTER
P002	4	1
P003	2	2
P001	3	2
P004	2	1

1. SELECT MIN(PRICE), MAX(PRICE) FROM COMPUTER;
2. SELECT COMPANY, COUNT(*) FROM COMPUTER GROUP BY COMPANY HAVING COUNT(COMPANY) > 1;
3. SELECT PROD_NAME, QTY_SOLD FROM COMPUTER C, SALES S WHERE C.PROD_ID=S.PROD_ID AND TYPE = 'INPUT';
4. SELECT PROD_NAME, COMPANY, QUARTER FROM COMPUTER C, SALES S WHERE C.PROD_ID=S.PROD_ID;

Answer 1

1. 
   

   Min(Price)	Max(Price)
   200	4300

2. 
   

   Company	Count(*)
   LOGITECH	2
   CANON	2

3. 
   

   PROD_NAME	QTY_SOLD
   MOUSE	3
   KEYBOARD	2
   JOYSTICK	2

4. 
   

   PROD_NAME	COMPANY	QUARTER
   MOUSE	LOGITECH	2
   LASER PRINTER	CANON	1
   KEYBOARD	LOGITECH	2
   JOYSTICK	IBALL	1