Question

Consider the tables Admin and Transport given below:

                       Table: Admin

S_id	S_name	Address	S_type
S001	Sandhya	Rohini	Day Boarder
S002	Vedanshi	Rohtak	Day Scholar
S003	Vibhu	Raj Nagar	NULL
S004	Atharva	Rampur	Day Boarder

            Table: Transport

S_id	Bus_no	Stop_name
S002	TSS10	Sarai Kale Khan
S004	TSS12	Sainik Vihar
S005	TSS10	Kamla Nagar

Write SQL queries for the following:

1. Display the student name and their stop name from the tables Admin and Transport.
2. Display the number of students whose S_type is not known.
3. Display all details of the students whose name starts with 'V'.
4. Display student id and address in alphabetical order of student name, from the table Admin. 

Answer 1

1. Select A.S_name, T.Stop_name from Admin A, Transport T where A.S_id=T.S_id;
2. Select count(*) from Admin where S_type IS NULL;
3. Select A.*, T.Bus_no, T.Stop_Name from Admin A, Transport T where A.S_id=T.S_id and A.S_name like "V%";
4. Select S_id, Address from Admin order by S_name;