KnowledgeBoat Logo

Informatics Practices

Give output for following SQL queries as per given table(s) :

Table : SENDER

SenderIDSenderNameSenderAddressSenderCity
ND01R Jain2, ABC ApptsNew Delhi
MU02H Sinha12, NewtownMumbai
MU15S Jha27/A, Park StreetMumbai
ND50T Prasad122-K, SDANew Delhi

Table : RECIPIENT

RecIDSenderIDRecNameRecAddressRecCity
KO05ND01R Bajpayee5, Central AvenueKolkata
ND08MU02S Mahajan116, A ViharNew Delhi
MU19ND01H Singh2A, Andheri EastMumbai
MU32MU15P K SwamyB5, C S TerminusMumbai
ND48ND50S Tripathi13, B1 D, Mayur ViharNew Delhi

(i) SELECT DISTINCT SenderCity FROM Sender ;

(ii) SELECT A.SenderName, B.RecName
FROM Sender A, Recipient B
WHERE A.SenderID = B.SenderID AND B.RecCity = 'Mumbai' ;

(iii) SELECT RecName, RecAddress FROM Recipient
WHERE RecCity NOT IN('Mumbai', 'Kolkata') ;

(iv) SELECT RecID, RecName FROM Recipient
WHERE SenderID = 'MU02' OR SenderID = 'ND50' ;

SQL Queries

1 Like

Answer

(i)

Output
+------------+
| SenderCity |
+------------+
| MUMBAI     |
| NEW DELHI  |
+------------+

(ii)

Output
+------------+-----------+
| SenderName | RecName   |
+------------+-----------+
| R JAIN     | H SINGH   |
| S JHA      | P K SWAMY |
+------------+-----------+

(iii)

Output
+------------+-----------------------+
| RecName    | RecAddress            |
+------------+-----------------------+
| S MAHAJAN  | 116, A VIHAR          |
| S TRIPATHI | 13, B1 D, MAYUR VIHAR |
+------------+-----------------------+

(iv)

Output
+-------+------------+
| RecID | RecName    |
+-------+------------+
| ND08  | S MAHAJAN  |
| ND48  | S TRIPATHI |
+-------+------------+

Answered By

2 Likes


Related Questions