Answer to Question #158498 in Databases | SQL | Oracle | MS Access for Adnan Khan

Question

Q.4. Answer the following as SQL queries. Also write corresponding relational algebra expression:                                                                                                                 

           a. Number of rakats prayed as Qaza by each person

           b. How many females have skipped fajar salah on 1st shawwal

           c. How many salah are missed by Mr. Noman

           d. Average time M. Noman takes for praying Isha Salah

           e. Which salah is missed mostly by M. Saleem

           f. Which salah is missed the second most by all people

Answer 1

a) select distinct (Person name ) from table2 where prayed rakats ="Qaza";

the question does not have proper primary keys for every table and Schema is not proper.