Question

MySQL Answer Queries from the given Train Table Wrong Answers will be reported as soon... Plz Don't put any spam messages i'm requesting u guys...!!!

Answer 1

Answer:

select * from trains where start = New delhi;

select pnr, pname, gender, age from trains t, passengers p where age < 50;

select count(gender) from passenger where gender = "female";

select * from passenger p, Trains t where tno = "12015";

you can do others ;-}

Explanation:

Answer 2

i) SELECT * FROM Trains WHERE START='NEW DELHI';

ii) SELECT PNR,PNAME,GENDER ,AGE FROM PASSENGERS WHERE AGE<50;

iii) SELECT GENDER,COUNT(*) FROM PASSENGERS GROUP BY GENDER;

iv) SELECT * FROM PASSENGERS WHERE TNO='12015';

v) MAX(TRAVELDATE) MIN(TRAVELDATE)

2018-11-10                 2018-05-09

vi) END            COUNT(*)

amristar junction 2

habibganj          2

new delhi         4

vii) TRAVELDATE

2018-12-25

2018-11-03

2018-11-10

2018-10-12

2018-05-09

vii) TNAME     PNAME

amritsar mail      N S SINGH

swarna shatabdi  R SHARMA