Question

1) Write or select the correct SQL statement that satisfies the following case: Find value 'Dern' of the 'Style' attribute in the table 'Invoice_Line'

2)Write or select the correct SQL statement that satisfies the following case: Find value '36' of the 'Quantity' attribute in the table 'Invoice_Line'

3)Write or select the correct SQL statement that satisfies the following case: Find value 'Willis' of the 'Last Name' attribute in the table 'Contacts'

4)Write or select the correct SQL statement that satisfies the following case: Find value '08/04/2014' of the 'Invoice Date' attribute in the table 'Invoice'

5)Write or select the correct SQL statement that satisfies the following case: Find value 'Gregory' of the 'Nickname' attribute in the table 'Customer'

6)Write or select the correct SQL statement that satisfies the following case: Find value 'James' of the 'First Name' attribute in the table 'Contacts'

7)Write or select the correct SQL statement that satisfies the following case: Find value 'Williams' of the 'First Name' attribute in the table 'Vendors'

8)Write or select the correct SQL statement that satisfies the following case: Find value '58' of the 'Age' attribute in the table 'Vendors'

9)Write or select the correct SQL statement that satisfies the following case: Find value 'Julianne' of the 'First Name' attribute in the table 'Customer'

10)Write or select the correct SQL statement that satisfies the following case: Find value '47' of the 'Days Late' attribute in the table 'Invoice'

So, I answered these questions with the table first, but that is incorrect. So, I am just confused their has to be a flow to this, and I am just plan confused.

Answer 1

Note that, in the following queries I used SELECT * FROM table_name statements. If you want to display only the field name just use the field name instead of the '*'.

You should ensure that the field names in table are same in all queries.

1) SELECT * FROM Invoice_Lane WHERE Style='Dern';

This statement selects all the details from table Invoice_Lane where the Style attribute value is Dern.

If we want to display only the field name instead of all details, use SELECT Style FROM Invoice_Lane WHERE style='Dern';

2) SELECT * FROM Invoice_Lane WHERE Quantity=36;

This statement selects all the details from Invoice_Lane table where the Quantity value is 36

3) SELECT * FROM Contacts WHERE LastName='Willis';

This statement selects all the details from Contacts table where Last Name is Willis.

4)SELECT * FROM Invoice WHERE InvoiceDate='08/04/2014';

This statement Selects row from Invoice table where InvoiceDate='08/04/2014'

5)SELECT * FROM Customer WHERE Nickname='Gregory';

This statement prints the row from Customer table where NaNaickname is Gregory

6)SELECT * FROM Contacts WHERE FirstName='James';

This statement prints thw corresponding row fron Contacts table where FirstName is James

7)SELECT * FROM Vendors WHERE FirstName='Williams';

This statement prints the row with firstname is Williams

8)SELECT * FROM Vendors WHERE Age=58;

This statement prints row with age is 58 from Vendors table.

9)SELECT * FROM Customer WHERE FirstName='Julianne';

This Statement prints details from Customer table where FirstName is Juliane.

10)SELECT * FROM Invoice WHERE DaysLate=47;

This statement prints details from Invoice table where DaysLate is 47.