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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!