Let us worry about your assignment instead!

We Helped With This Database Programming Homework: Have A Similar One?

More InfoSql Help

Short Assignment Requirements

Link to sql file on google drive: https://drive.google.com/file/d/1nBXFuujXudCjzyvQ282NWB3qZhXplvmr/view?usp=drivesdk

Assignment Description

CIS 487 – Database Programming                                                                              Midterm Part 2

Please use the NorthwindTablesAndData.sql file to populate an empty database with tables and data. All problems except #1 and #2 are based on Northwind. Each query is worth 12.5 points.  Not all queries are the same level of difficulty. This is intentional. I would appreciate it if you separate your answers with a comment containing the problem number.


You will receive a zero if you do not turn in a single .sql file containing each solution for this part of the midterm.


1.      Write a query to display the current date and time on the database server in ISO8601 format. The title of the result should be ISO8601 Date. Do not use a FROM clause.


2.      Given the variable definition below

DECLARE @Data VARCHAR(100) = 'Computer science is no more about computers than astronomy is about telescopes.'


Use the variable in a SELECT to display the following:

* astronomy is about telescopes.*


You may use only three literals in your query: the digit 1, '*' and 'than '. 


After @Data is declared, treat it just like a column, such as:

DECLARE @Data VARCHAR(100) ) = 'Computer science is no more about computers than astronomy is about telescopes.'



3.      Using the Northwind database provided in the sql script, display all of the products and their categories.  The display must have the category name first and the product name second. Sort the results alphabetically by category. Within a category, sort the product names alphabetically. If a product doesn’t have a category, it must not show up in the results.


4.      Using the Northwind database, show all the order ids, order dates and the company name that shipped the order. Display the results in order of order id. If an order doesn’t have a company that shipped it, do not display the order.


5.      Show all the employees with their names in ‘last, first’ format and who they report to using ‘last, first’ format. If they don’t report to anyone, show their supervisor as “No one.” Here are the required results. Hint: Alias the Employee table as Supervisor




CIS 487 – Database Programming                                                                              Midterm Part 2

6.      Show all the territory descriptions and the employees assigned to those territories. Display the territory even if there are not employees associated with that territory. For those territories without any employees, show the employee name as “No employees.”  Sort the results in ascending order by territory and by employee name within territory. Below is how the first few rows should appear. There are more rows than this in the actual result set.





7.      Write a query to show the total number of employees for each territory. Show the number of employees first and then the territory description. Sort the results by the number of employees per territory with the highest number of employees first. If there are territories with the same number of employees, then sort the results by territory description within number of employees. Below is a sample of the expected output.






8.      Now show the number of employees by region. Below is the expected result including sort order and column names. 



9.      Show the supervisor(s) that have 4 or more employees. It is okay to hard code the 4 this time. You must use the appropriate HAVING clause. Here is the expected result. Notice the column headers.



10.  Show only the territory with the most employees. You must use aggregate functions in the query to only show the correct territory. Your query must use a HAVING clause with a subquery.  Hint: Use your solution to #7 as a derived table for the subquery in the HAVING clause. Here is the entire expected result.


Frequently Asked Questions

Is it free to get my assignment evaluated?

Yes. No hidden fees. You pay for the solution only, and all the explanations about how to run it are included in the price. It takes up to 24 hours to get a quote from an expert. In some cases, we can help you faster if an expert is available, but you should always order in advance to avoid the risks. You can place a new order here.

How much does it cost?

The cost depends on many factors: how far away the deadline is, how hard/big the task is, if it is code only or a report, etc. We try to give rough estimates here, but it is just for orientation (in USD):

Regular homework$20 - $150
Advanced homework$100 - $300
Group project or a report$200 - $500
Mid-term or final project$200 - $800
Live exam help$100 - $300
Full thesis$1000 - $3000

How do I pay?

Credit card or PayPal. You don't need to create/have a Payal account in order to pay by a credit card. Paypal offers you "buyer's protection" in case of any issues.

Why do I need to pay in advance?

We have no way to request money after we send you the solution. PayPal works as a middleman, which protects you in case of any disputes, so you should feel safe paying using PayPal.

Do you do essays?

No, unless it is a data analysis essay or report. This is because essays are very personal and it is easy to see when they are written by another person. This is not the case with math and programming.

Why there are no discounts?

It is because we don't want to lie - in such services no discount can be set in advance because we set the price knowing that there is a discount. For example, if we wanted to ask for $100, we could tell that the price is $200 and because you are special, we can do a 50% discount. It is the way all scam websites operate. We set honest prices instead, so there is no need for fake discounts.

Do you do live tutoring?

No, it is simply not how we operate. How often do you meet a great programmer who is also a great speaker? Rarely. It is why we encourage our experts to write down explanations instead of having a live call. It is often enough to get you started - analyzing and running the solutions is a big part of learning.

What happens if I am not satisfied with the solution?

Another expert will review the task, and if your claim is reasonable - we refund the payment and often block the freelancer from our platform. Because we are so harsh with our experts - the ones working with us are very trustworthy to deliver high-quality assignment solutions on time.

Customer Feedback

"Thanks for explanations after the assignment was already completed... Emily is such a nice tutor! "

Order #13073

Find Us On

soc fb soc insta

Paypal supported