Answer the following as SQL queries. Also write corresponding relational algebra expression: (15 marks)

• Table 1 ------Person name, gender , age, date and time
• Table 2 ------Person name, prayed Rakats
• Table 3 ------ Person name, on-time/ off time
• Table 4------- Person name , time to pray

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