Oracle 12c: SQL
Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
Students have asked these similar questions
7-Display last name of employees whose manager is KING.8-Display last name, salary and job title of all employees who earns more than the lowest salary. (Employees andJobs)9-Display all employees including King, who has no manager. Order the results by the employee number.10-Display the name and hire date of any employee hired after employee Davis
Who has rented movies in Japanese language? Return only the first five distinct results in alphabetical order by last name.(Hints: In the language table, there is a field “name” that contains the film language names.) Display: first name and last name
2. Based on Table 1 and Table 2, write Transact-SQL queries to answer the following questions. Provide the output of each query. (Hint: Use Microsoft SQL Server to write query) Table 1: PAINTING Painting No 2018 2023 2041 2942 2045 2103 Table 2: PAINTER Painter No 10014 10015 10016 Title Dawn Thunder The Starry Night Sunrise The Night Cafe The Gardener Sunset Title Mr Ms Mr Name Johan Anne Michael Painter_No 10016 10015 10015 10014 10015 10014 Phone 844-2573 894-1238 Null Gallery No Price (RM) 1000 1600 900 7000 5600 2000 18 18 23 24 18 24 Email johan@gmail.com anne@gmail.com michael@gmail.com
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr