Question
Please help Solving in SQL database 1) TRUNC command for salary Display employee last_name and salary for those employees who work in department 80. Give
Please help Solving in SQL database
1)
TRUNC command for salary
Display employee last_name and salary for those employees who work in department 80. Give each of them a raise of 5.333% and truncate the result to two decimal places.
2)
Select all the students whose last names end with e, and change the heading of the column to show Names of Students.
3) Show all students id, first name, last name whose first name that doesn't start with second letter "e" ?
4) Show all faculty id, first name, last name, dob, but only dob before May 2, 1976 ? 5)
Show faculty id, first name, last name but only for faculty id with number 11115
6)
John has a yearly salary of 135000 dollars. Create that sentence with sql command 7) Show employees that do not work for IBM, Oracle, AWS ?
8)
Show all orders comming from state of Florida and food company is Hershey from order id that is less 1000
9)
Remove duplicate from state, country from order table but total order must be higher then 50 and must be in state alphabetical order
10)
Show all numbers which you know 6 numbers but you forgot the 7 digit:
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