Given the following table (Authors table) AuthorID FirstName LastName 1 Paul Deitel 2 Harvey Deitel 3...

Question

Question

Given the following table (Authors table) AuthorID FirstName LastName 1 Paul Deitel 2 Harvey Deitel 3...

Given the following table (Authors table)

AuthorID	FirstName	LastName
1	Paul	Deitel
2	Harvey	Deitel
3	Abbey	Deitel
4	Dan	Quirk
5	Michael	Morgano

What does the following Query produce when executing on the above table:

SELECT AuthorID, FirstName, LastName
FROM Authors
WHERE LastName LIKE 'D%'

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

AuthorID	FirstName	LastName
1	Paul	Deitel
2	Harvey	Deitel
3	Abbey	Deitel

Add a comment

Answer 2

Similar Homework Help Questions

In this hands-on project, you will create an application that allows the user to connect to...

In this hands-on project, you will create an application that allows the user to connect to a database and query the database. Write a Java query application that allows the user to connect to the books database and query the books database. Provide the following predefined queries: Select all authors from the Authors table Select a specific author and list all books for that author. Include each book’s title, year and ISBN. Display the appropriate data for each query. Given...
Do these codes look right for the following 5 statements. This is using Oracle SQL: Write...

Do these codes look right for the following 5 statements. This is using Oracle SQL: Write a query that displays the title, ISBN, and wholesale cost of books whose wholesale cost is more than the average of all books. Format the retail price with dollars and cents. Write a query that displays the title and publication date of the oldest book in the BOOKS table. Format the date with the complete name of the month and a comma after the...
5. (3 pts) Write a SQL command that will insert a record into the “appts” table...

5. (3 pts) Write a SQL command that will insert a record into the “appts” table above for a student named “Kelly”, where the advisor is “JSR”, and the room number is 5. 6. (3 pts) Write a SQL command that will display the name of students that are associated with the advisor named “JSR”. 7. (7 pts) Use the FRIENDS table to answer the following questions. LASTNAME FIRSTNAME AREACODE PHONE ST ZIP --------------- ---------------- -------- -------- -- ------ BUNDY ...

MySQL Practice Student StudentID FirstName LastName Street City State Zipcode 10001 Bruce Wayne 123 Elm Street...

MySQL Practice Student StudentID FirstName LastName Street City State Zipcode 10001 Bruce Wayne 123 Elm Street Gotham City New York 10028 10002 Peter Parker 456 Corallville New York New York 10037 10003 Tony Stark 777 Faith Ave Malibu California 60263 School SchoolID SchoolName City State Zipcode 19837 Gotham High School Gotham City New York 10028 83649 Midtown High School New York New York 10037 73934 MIT Cambridge Massechusetts 02139 Attendee AttendeeID StudentID 100 10001 200 10002 300 10003 Attend AttendeeID...
Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following would...

Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following would find all employees whose name begins with the letter "S" using Microsoft Access? A) SELECT * FROM EMPLOYEE WHERE Name IN ['S']; B) SELECT EmpNo FROM EMPLOYEE WHERE Name LIKE 'S'; C) SELECT * FROM Name WHERE EMPLOYEE LIKE 'S*'; D) SELECT * FROM EMPLOYEE WHERE Name LIKE 'S%'; E) None of the above.
4. Suppose you are given the following demand schedule for 4 individuals. Use this information to...

4. Suppose you are given the following demand schedule for 4 individuals. Use this information to complete the rest of the question. Price Ringo Paul John George Market 0 0 0 248 9 6 8 16 10 10 12 32 11 | 14 | 16 40 50 12 18 20 48 a) (5 points) Fill in the blanks above to determine the market demand schedule. b) (4 points) How does Ringo's own-price elasticity of demand compare with the market's own-price...

SE #retake Saved The following table shows information for Hayek's Maps, a perfectly competitive firm. 3...

SE #retake Saved The following table shows information for Hayek's Maps, a perfectly competitive firm. 3 a. Complete the MC column in the table: MC TC $ 85 Output B 1 2 3 170 oints 250 8 320 01:21:46 4 410 5 525 6 665 7 845 8 1,045 b. Given the prices in table below, fill in columns 2, 3, 4 and 5 of table. (Assume that partial units cannot be produced.) If entering any negative numbers be sure...
Numerical Methods 125% 4 16 (i) [1 mark] Given the data points {(ak,Uk))3-{(-1,03), (2.-01), (0.0.1)), the ai. Which of least-squares regression line can be written in the form y - do the following 2...

Numerical Methods 125% 4 16 (i) [1 mark] Given the data points {(ak,Uk))3-{(-1,03), (2.-01), (0.0.1)), the ai. Which of least-squares regression line can be written in the form y - do the following 2 x 2 linear systms of equations are the normal equations that determine the unknown coefficients do and ai? 0.5 0.6 0.6 A. 1 3 a1 B. 0.5 C. 0.5 0.5 0.6 0.26 [ao D.13 0.6」[al -0.5 0.6 3 1 o E. 5 La G) [I mark]...
These are my answere to the following questions: are they right? 1. B 2. T 3....

These are my answere to the following questions: are they right? 1. B 2. T 3. T 4. T 5. F 6. T 7. A 8. D 9. E 10. B 11. B 12. A 13. A 14. D 15. C 16. D 17. T 18. C 19. T 20. T 21. T 22. A 23. T 24. D 25. B 26. A 27. A 28. A 29. T 30. C 31. D 32. A 33. T 34. F 35....

Given the following table (Authors table) AuthorID FirstName LastName 1 Paul Deitel 2 Harvey Deitel 3...

Homework Answers

Add Answer to:
Given the following table (Authors table) AuthorID FirstName LastName 1 Paul Deitel 2 Harvey Deitel 3...

Post as a guest

Earn Coins

In this hands-on project, you will create an application that allows the user to connect to...

Do these codes look right for the following 5 statements. This is using Oracle SQL: Write...

5. (3 pts) Write a SQL command that will insert a record into the “appts” table...

MySQL Practice Student StudentID FirstName LastName Street City State Zipcode 10001 Bruce Wayne 123 Elm Street...

Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following would...

4. Suppose you are given the following demand schedule for 4 individuals. Use this information to...

SE #retake Saved The following table shows information for Hayek's Maps, a perfectly competitive firm. 3...

Numerical Methods 125% 4 16 (i) [1 mark] Given the data points {(ak,Uk))3-{(-1,03), (2.-01), (0.0.1)), the ai. Which of least-squares regression line can be written in the form y - do the following 2...

These are my answere to the following questions: are they right? 1. B 2. T 3....

Given the following table (Authors table) AuthorID FirstName LastName 1 Paul Deitel 2 Harvey Deitel 3...

Homework Answers

Add Answer to: Given the following table (Authors table) AuthorID FirstName LastName 1 Paul Deitel 2 Harvey Deitel 3...

Post as a guest

Earn Coins

Add Answer to:
Given the following table (Authors table) AuthorID FirstName LastName 1 Paul Deitel 2 Harvey Deitel 3...