Question: QUESTION 19 Consider the following database for projects in a class: Student(sid, name, dept) Project(pid, topic, budget) Team(sid, pid) Relation Student contains a row for

QUESTION 19 Consider the following database for projects in a class: Student(sid, name, dept) Project(pid, topic, budget) Team(sid, pid) Relation Student contains a row for each student with a unique id, student name, and the department of each student. Each row in relation Project holds the unique id of a project, the topic area the students will be working on, and the estimated budget for the project. Finally, the table Team captures the assignments of students to projects. Which SQL query/queries would retrieve the total number of all projects? All queries are syntactically correct. O SELECT COUNT(*) FROM project; SELECT COUNT(pid) FROM project; SELECT SUM(pid) FROM project; O SELECT COUNT(budget) FROM project
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
