Question: Write SQL Scripts To Retrieve The Following Using The Oracle Demo Tables: 7. The Name Of All Customers Living In A Postcode Area Starting With ‘BS’. 8. The Customer Ids Of All Customers Whose Credit Limit Is Between 7000 And 12000. 9. List The Employee Numbers Of All Employees Who Were Hired In December Of Any Year. 10. List The Names And Job Title Of Write SQL scripts to retrieve the following using the Oracle demo tables: 7. The name of all customers living in a postcode area starting with ‘BS’. 8. The customer ids of all customers whose credit limit is between 7000 and 12000. 9. List the employee numbers of all employees who were hired in December of any year. 10. List the names and job title of all employees, with the most junior employee listed first. (use HIREDATE to determine seniority) 11. List the names of all employees supervised by managers (mgr) 7902, 7839 or 7566. Order the list by employee name. 12. Full details of the customer whose customer id is ‘GRE301’. 13. A list of all salesmen and their total salary and commission as a single field. Rename this column as ‘Total Salary’. 14. The customer id and credit limit of all customers in Bristol, Swindon or Leeds, ordered by credit limit, starting with the highest credit value. 15. The name of all customers with a customer id ending in 002 or with ‘W’ as the third letter of their surname. 16. List the name of all employees who work in department 10 or who are managers. 17. Produce an alphabetic listing of the name and salary of all employees with names begin with ‘S’ or ‘W’. 18. The name of all customers who do not live in Manchester. 19. Produce a list showing the customer name, the customer’s rep and the customer’s area. Display the area in full, where SW = South West NW = North West NE = North East SE = South East 20. Orders shipped more than 10 days after their order date are to be given a refund of 10% of the total order price. List the orderid of these orders, the number of days taken to ship the order, and the discount applicable. (uses the ORD table)
Write SQL Scripts To Retrieve The Following Using The Oracle Demo Tables:
To get the Solution, drop an email at [email protected]
Please feel free to send us your queries at: [email protected]
Problem Statement
To get the Solution, drop an email at [email protected]
Please feel free to send us your queries at: [email protected]