Question: What is wrong with the following SQL syntax for using a subquery? SELECT staffNo, fName, lName, position FROM staff WHERE branchNo = (SELECT branchNo FROM

What is wrong with the following SQL syntax for using a subquery? SELECT staffNo, fName, lName, position FROM staff WHERE branchNo = (SELECT branchNo FROM branch WHERE street = 163 Main St);

Nothing is wrong with the statement

The subquery needs to be in brackets {} rather than in parenthesis ().

the field branchNo needs to be listed in the first Select clause also

The two tables (staff and branch) must be listed in both FROM clauses

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!

Language SQL Need help with SQL Question Create a view vHW1_7_xxxx listing staff who have the highest salary in each of the branch city. You will need both Staff and Branch table. The output header...

Language SQL I need help with this question. Create a view vHW1_6_xxxx listing the city that has only one female staff working in the city. Your out header should be (city, count). So far i have...

Use the following relations to answer the questions below using relational algebra. Branch branchNo street city postcode B005 22 Deer Rd London SW1 4EW B007 16 Argyll St Aberdeen AB2 3SU B003 163...

Please help for the database Write SQL (Total 50 marks. There are ten (10) questions with five (5) marks for each correct answer.) 2. Consider the following seven relations for the DreamHome example:...

SQL Create a listing the project name, staff name and the staffs branch city for the same staff who working on the same project more than one time. You should use Project, Staff2, Branch, and Working...

04) (15pts) Show clients that have 3 or more properties for rent. Order by the number of properties for rent in descending order. first name last name client properties Heidi Nicolas Evelia Deon...

mysql CREATE TABLE branch ( branchno char(5) NOT NULL, street varchar(35) DEFAULT NULL, city varchar(10) DEFAULT NULL, postcode varchar(10) DEFAULT NULL, PRIMARY KEY (branchno) ); CREATE TABLE staff...

What itemized deductions must exceed a basic minimum (floor) before the taxpayer's taxable income is reduced for the excess amounts expended?

Find the area under the standard normal curve that lies a. Either to the left of 2.12 or to the right of 1.67. b. Either to the left of 0.63 or to the right of 1.54.

A company s current share price is $ 1 1 . 2 4 , and it intends to pay a dividend of $ 1 . 3 8 next year. Using the dividend discount model and assuming a constant growth rate of 5 % , what is the...

needing help Edmonton Pools manutactures swimming pool equipment. Edmonton has estimated the following manufacturing overhead rates using different independent situations (Click the icon to view the...

=+differences in home- and host-country costs of living?

=+2 What additional incentives and premiums will be required to motivate the

=+derived from the assignment will balance the costs?