Assignment Task
Task
Write and run SQL statements to complete the following tasks:
A. Write a SQL query to show customer number (customernumber), customer name (customername), city, post code (postalcode), state, country and credit limit (creditlimit) where the country of the customers is USA, the city name starts with B, and the credit limit (creditlimit) of a customer is greater than or equal to 23000 but less than or equal to 43000.
B. Show the managers (reportsto) and the number of employees under each manager where employee type (jobtitle) is ‘Sales Rep’. (2 marks)
C. Write a SQL query to retrieve the product vendor name (productvendor), number of product vendor (productvendor) and the average MSRP for each product vendor. (2 mark
Welcome to our Online Essay Writing Agency. Securing higher grades costing your pocket? Order your assignment online at the lowest price now! Our online essay writers are able to provide high-quality assignment help within your deadline. With our homework writing company, you can order essays, term papers, research papers, capstone projects, movie review, presentation, annotated bibliography, reaction paper, research proposal, discussion, or another assignment without having to worry about its originality – we offer 100% original content written completely from scratch
A-Plus Writing Help For University Students
Get expert assistance in any academic field. All courses and programs covered.
Get Help Now!We write papers within your selected deadline. Just share the instructions
