| hi guys im going over some oracle base help [message #669495] |
Wed, 25 April 2018 22:13  |
 |
lawrance
Messages: 2
Registered: April 2018
|
Junior Member |
|
|
im doing some training and having issues with some queries i have 4 tables and sub classes set as
student - student ID, names, gender, enrolment , postcode, age , date joined, music style, lessons booked
Teacher - teacher ID, name , music style, lessons booked, date joined, postcode
Band - band ID, date joined, music style
Venue - venue ID, name , booking date, address
the queries i have are
* list all new students who have joined after the 1st of july order by joined date
* list of all underage males musicians and their age sorted by first name
* count of teachers from each post code
* list of all current lessons booking sorted bu the style of music and the booking date
* a report on the students enrolled, the style of music and the teacher
these are the once i have tried if someone can help me with them
for the 1st one i have tried
1. select * from student where datejoined='1/7/18' sort by datejoined asc;
2. select * from student where student gender ='male' and student age < 18 sort by student name;
3. select * from teacher count teacher from postcode;
4.select lessons booked from teacher natural join student order by music style, booking date;
5. select student id from student where enrolled = 'yes' natural join teacher where style of music like'%rock%;
any help would be a great help thanks
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
