مجموعة اسئلة للمراجعة في ال Sql

1. List all the data of the Organization table

2. Display PFName,PLName, and PPhone for all the patients who live in 'Manama'
3. Display DocLName for all doctors whose salary is less than the average salary.
4. display PFName, PLName, and PPhone for all patients working in 'DID'.
5.List all the PCPRs of those patients whose both PArea and POrgNo are not assigned.
6. Create the Visit table adding in appropriate foreign key constraints.
the primary key is VisitNo
VisitNo number(5)
PCPR number(9)
DCPR Number(9)
Diagnostics Varchar2(25) should not be null
Treatment Varchar2(25)


7. insert the following data into the table:
VistaNo:22588
PCPR:500187578
DCPR:66010144
DiiagonsticsL Migraine
Treatment: null

8. Sakeena Ahmed is moving to Isa Town. Make the appropriate change to the database.

9. Increase the salary for all doctors by 100 BDs.

10. List the OrgName and OrgPOBox and number of patients of all of the organizations that have sent more than 10 patients to the hospital