Make a structured query language (SQL) for the following question in Access Data

Question

Make a structured query language (SQL) for the following question in Access Database (ill put into access database myself, just need the SQL): (I have provided the necessary info in screenshots. Screenshot 1 is the relationships, 2 is Attendance table, 3 is Courses table, 4 is Employees table).

3) Create an open ended query that prompts user for an input of a courseID, the result should show the number of students who passed the course and the number of students who failed. So given a courseID, the result should contains two fileds: Passed and number of students something like

Passed Number of students

  YES 3

  NO 1

All Access Obje H Employee: NAL CMIA Ascending Tis X Del Relati 1/1/2000 $3100.00 $6.110.00 9/23 1998 3/1/1956 $2,800.00 2/23/1997 810N1997 $3,400.00 2/1/1957 $3.200.00 $0.00 Ary do

Explanation / Answer

select
'YES' as Passed,
(select count(*) from Attendance where passed=true) as 'Number of students'
union
select
'No' as Passed,
(select count(*) from Attendance where passed=false) as 'Number of students';

I am assuming Your data is kept in Attendance table and field passed is a boolean type attribute.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.