Patient Doctor P ld PName Gender Age Aqib Male 25 DId D. Fname D Lname Salary City 2. Saima Female 36 Laiba Hafeez 50000 | Rwp 3 Fatima Female 29 2 Sameer Khan 80000 | Isb 4 Nouman Male 31 Muneeb Male...




  1. Assume the schema given above and identify the following queries are executable or not. If yes then draw their results, if not then mention their errors.




  • Select * from patient where age between not 25 and 31;

  • Select D_Fname+’ ‘+D_Lname as [name] from doctor where D_Fname like  ‘_[^ubs]%’ ;


Patient<br>Doctor<br>P ld<br>PName Gender Age<br>Aqib<br>Male<br>25<br>DId<br>D. Fname<br>D Lname Salary City<br>2.<br>Saima<br>Female<br>36<br>Laiba<br>Hafeez<br>50000 | Rwp<br>3<br>Fatima<br>Female<br>29<br>2<br>Sameer<br>Khan<br>80000 | Isb<br>4<br>Nouman Male<br>31<br>Muneeb Male<br>40<br>Talib<br>Ali<br>62000 | Isb<br>3<br>6.<br>Tariq<br>Male<br>38<br>4<br>Saleem<br>Iqbal<br>77000 Multan<br>7<br>Ikram<br>Male<br>26<br>Tania<br>Abbas<br>85000 Lahore<br>8.<br>Sadia<br>Female<br>27<br>Huda<br>Ahmad<br>68000 Rwp<br>a) Write SQL queries for the following.<br>

Extracted text: Patient Doctor P ld PName Gender Age Aqib Male 25 DId D. Fname D Lname Salary City 2. Saima Female 36 Laiba Hafeez 50000 | Rwp 3 Fatima Female 29 2 Sameer Khan 80000 | Isb 4 Nouman Male 31 Muneeb Male 40 Talib Ali 62000 | Isb 3 6. Tariq Male 38 4 Saleem Iqbal 77000 Multan 7 Ikram Male 26 Tania Abbas 85000 Lahore 8. Sadia Female 27 Huda Ahmad 68000 Rwp a) Write SQL queries for the following.

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here