Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Give me oracle sql command for the following questions - Q 1 . Write a query to display the tomorrows date in the following format:
Give me oracle sql command for the following questions
Q Write a query to display the tomorrows date in the following format:September th of year the result will depend on the day when you RUNEXECUTE this query.Label the column Tomorrow.
Q For each product in category that its listprice is less than $ and greater than show product ID product name, list price, and the new list price increased by Display a new list price as a whole number integerIn your result, add a calculated column to show the difference of old and new list prices. Name this column asPrice Difference.The query returns rows.Sort the result according to product ID
Q Write a query that displays the full name and job title of the manager for employees whose job title is "Finance Manager" inthe following format:Jude Rivera works as Administration Vice President.The query returns row.Sort the result based on employee ID
Q For employees hired in November display the employees last name, hire date and calculate the number of months between the current date and the date the employee was hired, considering that if an employee worked over half of a month, it should be counted as one month.Label the column Months Worked.The query returns rows.Sort the result first based on the hire date column and then based on the employee's last name.
Q Display each employees last name, hire date, and the review date, which is the first Friday after five months of service. Show the result only for those hired before January Label the column REVIEW DATE. Format the dates to appear in the format like: TUESDAY, January the ThirtyFirst of year You can use ddspth to have the above format for the day Sort first by review date and then by
last name.The query returns rows.
Q For all warehouses, display warehouse id warehouse name, city, and state. For warehouses with the null value for the state column, display unknown. Sort the result based on the warehouse IDThe query returns rows.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started