Question: Note:All information is correct and given please provide only relational algebra a. Number of rakats prayed as Qaza by each person answer) select distinct(Person name
Note:All information is correct and given please provide only relational algebra
a. Number of rakats prayed as Qaza by each person
answer) select distinct(Person name ) from table2 where prayed rakats ="Qaza";
b. How many females have skipped fajar salah on 1st shawwal
answer) SELECT COUNT (name) from female where question1=Null
c. How many salah are missed by Mr. Noman
answer) SELECT Count(SALAH) From SALAH WHERE follow=false
d) Average time M. Noman takes for praying Isha Salah
answer) select AVG(time) from prayer where name ="M.Noman"
e) Which salah is missed mostly by M. Saleem
answer)SELECT name from slalah where repetation=max
f) Which salah is missed the second most by all people
answer)select name from salah where repetation
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
