Answers
(a) 1023.4
(b) 13
(c) MASTER
(d) 0.6
(e) 3125
(f) 120
(g) 121
(h) 65467
(i) 12340
(j) 0
(k) 6
(l) 3244.2
(m) 12
(n) 19.467
(o) 1010
(p) 1177
(q) 101
(r) 3.872
(s) 22.446
(t) 300.43
(u) 13333
(v) ABS Public School
(w) 17
(x) abs public school
(y) ABS
(z) ABS PUBLIC SCHOOL
(aa) DIA IS GR
1-
CREATE TABLE HOSPITAL (
PNo INT PRIMARY KEY,
Name VARCHAR(30),
Age INT,
Department VARCHAR(30),
Dateofadm DATE,
Charges INT,
Sex CHAR(1)
);
2. DESC HOSPITAL;
3. SELECT * FROM HOSPITAL WHERE Department='Cardiology';
4. SELECT Name … WHERE Department='ENT' AND Sex='F';
5. SELECT Name, Dateofadm … ORDER BY Dateofadm;
6. SELECT Name, Charges, Age … WHERE Sex='F';
7. COUNT(*) … Age<30;
8. SUM(Charges) GROUP BY Department;
9. SUM(Charges) GROUP BY Department HAVING MAX(Charges)>=300;
10. ALTER TABLE … ADD Address CHAR(20);
11. ALTER TABLE … MODIFY Address CHAR(25);
12. ALTER TABLE … CHANGE Address Home_address CHAR(25);
13. ALTER TABLE … DROP COLUMN Home_address;
14. 5
15. 16
16. 500
17. 383.33
(a) SELECT * FROM STUDENT
WHERE Department = 'History';
(b) SELECT Name FROM STUDENT
WHERE Department = 'Hindi' AND Sex = 'F';
( c ) SELECT Name, Dateofadm FROM STUDENT
ORDER BY Dateofadm ASC;
(d) SELECT Name, Fees, Age FROM STUDENT
WHERE Sex = 'M';
(e) SELECT COUNT(*) FROM STUDENT
WHERE Age > 23;
(f) INSERT INTO STUDENT VALUES
(9, 'Zaheer', 36, 'Computer', '1997-03-12', 230, 'M');
(g)(i) 3
(g)(ii) 25
(g)(iii) 235
(g)(iv) 1310
(A)SELECT * FROM TEACHER
WHERE Department = 'History';
(B)SELECT Name FROM TEACHER
WHERE Department = 'Maths' AND Sex = 'F';
(C) SELECT Name, Dateofjoin FROM TEACHER
ORDER BY Dateofjoin ASC;
(D) SELECT Name, Salary, Age FROM TEACHER
WHERE Sex = 'M';
(E) SELECT COUNT(*) FROM TEACHER
WHERE Age > 23;
(F) INSERT INTO TEACHER VALUES
(9, 'Raja', 26, 'Computer', '1995-05-13', 23000, 'M');
(G)(i) 3
(G)(ii) 35
(G)(iii) 23500
(G)(iv) 23000
(A)SELECT * FROM CLUB
WHERE SPORTS = 'SWIMMING';
(B)SELECT COACH_NAME, DATEOFAPP FROM CLUB
ORDER BY DATEOFAPP DESC;
(C ) SELECT COACH_NAME, PAY, AGE, (PAY*0.15) AS BONUS
FROM CLUB;
(D) INSERT INTO CLUB VALUES
(11, 'RAJIV', 40, 'Hockey', '2005-05-27', 2006, 'M');
(E)(i) 5
(E)(ii) 34
(E)(iii) 1100
(E)(iv) 9806
(A)SELECT NAME
FROM GRADUATE
WHERE DIVI = 1 ORDER BY NAME;
(B)SELECT NAME, STIPEND, SUBJECT, (STIPEND * 12) AS YEARLY_STIPEND FROM
GRADUATE;
(C)SELECT COUNT(*)
FROM GRADUATE
WHERE SUBJECT = 'PHYSICS' OR SUBJECT = 'COMPUTER SC';
(D)INSERT INTO GRADUATE
(SNO, NAME, STIPEND, SUBJECT, AVERAGE, DIVI)
VALUES
(11, 'KAJOL', 300, 'COMPUTER SC', 75, 1);
(E)
(i) 63
(ii) 1000
(iii) 408.33
(iv) 4
(A)SELECT Name
FROM SPORTS
WHERE Grade1 = 'C' OR Grade2 = 'C';
(B)SELECT COUNT(*)
FROM SPORTS
WHERE (Game1 = 'Cricket' AND Grade1 = 'A')
OR (Game2 = 'Cricket' AND Grade2 = 'A');
( C) SELECT Name FROM SPORTS
WHERE Game1 = Game2;
(D) SELECT Game1, Game2
FROM SPORTS
WHERE Name LIKE 'A%';
(E) ALTER TABLE SPORTS ADD Marks INT;
(F) UPDATE SPORTS
SET Marks = 200
WHERE Grade1 = 'B'
OR (Grade1 = 'A' AND Grade2 = 'A');
(G) SELECT * FROM SPORTS
ORDER BY Name;
(A)SELECT ItemName FROM Lab
WHERE DateOfPurchase > '2007-10-31';
(B)SELECT ItemName FROM Lab
WHERE DATE_ADD(DateOfPurchase, INTERVAL Warranty YEAR) >= '2025-08-18';
( C) SELECT ItemName, DateOfPurchase
FROM Lab WHERE Quantity > 3
ORDER BY DateOfPurchase ASC;
(D) SELECT ItemName, CostPerItem, Quantity FROM Lab
WHERE DATE_ADD(DateOfPurchase, INTERVAL Warranty YEAR) < '2025-08-18';
(E) SELECT COUNT(*) FROM Lab
WHERE CostPerItem > 10000;
(F) INSERT INTO Lab
VALUES (8, 'VCR', 10000, 2, '2010-02-02', 1, 2);
