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



Write SQL queries for the following.




  • Display full name of doctors whose first name is other than Tania.

  • Display first name of doctors whose first name contains any of vowels (a,e,i,o,u).

  • Display names of those patients whose name’s second letter is neither ‘a’ nor ‘d’


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

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

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here