Question: QUESTION 1 2 points Saved Given a table named Products with columns ProdID, ProdName, ProdQOH, and ProdPrice, which of the following is the SQL syntax

QUESTION 1 2 points Saved Given a table named Products with columns ProdID, ProdName, ProdQOH, and ProdPrice, which of the following is the SQL syntax to display all columns and only the rows with a ProdQOH more than 50? SELECT ALL FROM Customers WITH ProdQOH greater than 50; SELECT ALL FROM Customers WITH ProdQOH> 50; SELECT FROM TABLE Customers WHERE ProdQOH is greater than 50; SELECT FROM Customers WHERE ProdQOH > 50: QUESTION 2 2 points Saved A typical equi-join matches the primary key values from one table to the values of another primary key foreign key superkey composite
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
