Posted - 04/13/2013 : 01:01:07
| Hi, this is my first time learn SQL and I can not do my work.
How to do
1. Show a list of appointments for June 2011. Provide the doctor and patients full name,
disease name (if any diagnosed), date & time of appointment together in this format
‘YYYY-MON-DD HH:MM’, consultant room number used, and status (i.e. Done). Show
these appointments in date & time order
There are doctor,patient and appointment table.
2. Create a view called “todays_appointments”. The view should list all appointments for the
current day. Include the appointment date and time, the doctor’s name, the patient’s name
and phone number, and done field. Order the view into doctor’s name, then order by the
3. List all appointments made by patients in the suburb RICHMOND, during the 2010 year
that have not been diagnosed with any diseases. Show the name of the patient and the date
and time of the appointment.
There are patient, appointment and disease table.
Please the help.