need some one good at MIS major. and the homework is about SQL server.
LAB 4 – DPC Antiques Data Set (Focus – GROUP BY & Aggregate):
1. Write an SQL statement that displays the training names and training costs for courses that cost between 1000 and 1200. Don’t use the BETWEEN Clause.
2. Using the BETWEEN Clause, write an SQL statement that displays the training names and training costs for courses that cost between 1000 and 1200. Order the output by Training Cost from highest to lowest.
3. Write an SQL statement that displays training IDs and Training names for all courses that contain the word ‘customer’ in the training description. Order the output by training name from A-Z.
4. Write an SQL statement that shows any Null values for States in the CUSTOMER Table.
5. Write an SQL statement to count the number of customers in the CUSTOMER Table. Include an Aliases when appropriate.
6. Write an SQL statement that counts the number of customers from Texas. Include an
7. Write an SQL statement that show the last name closest to Z. Include an Aliases when appropriate.
8. Write an SQL statement that lists last names and first names of all customers. Order the rows from A to Z for last name first, and then first name.
9. Write an SQL statement that shows the lowest and highest employee commission. Include an Aliases when appropriate.
10. Write an SQL statement that shows the employees ID and highest employee commission. Group the data by employees ID. Include an Aliases when appropriate.
11. Write an SQL statement that shows the Customers ID and largest purchase. Don’t include groups where the largest purchase was less than 1000. Include an Aliases when appropriate.
12. Write an SQL statement that shows Gender, and the total number or men and women that work for DPC Antiques. Order the output by the total from highest to lowest. Include an Aliases when appropriate.
13. Write an SQL statement that shows the average salary of each employee. Don’t include salaries below 30000 in the calculation. Include an Aliases where appropriate.
14. Write an SQL statement that shows the State and average salary of each employee. Don’t include salaries below 40000 in the calculation. Include an Aliases when appropriate. In addition, group the averages by State. Don’t include groups with less than 2 employees.
15. Write an SQL statement that shows employee IDs that earned an A or B in the training with a training ID of 1.
16. Write an SQL statement that shows employee IDs that have completed more than one class with a grade of B or better. Include an Aliases when appropriate.
Calculate the price of your order
Select your paper details and see how much our professional writing services will cost.
- Freebies
- Format
- Formatting (MLA, APA, Chicago, custom, etc.)
- Title page & bibliography
- 24/7 customer support
- Amendments to your paper when they are needed
- Chat with your writer
- 275 word/double-spaced page
- 12 point Arial/Times New Roman
- Double, single, and custom spacing
-
We care about originality
Our custom human-written papers from top essay writers are always free from plagiarism.
-
We protect your privacy
Your data and payment info stay secured every time you get our help from an essay writer.
-
You control your money
Your money is safe with us. If your plans change, you can get it sent back to your card.
How it works
-
1
You give us the detailsComplete a brief order form to tell us what kind of paper you need.
-
2
We find you a top writerOne of the best experts in your discipline starts working on your essay.
-
3
You get the paper doneEnjoy writing that meets your demands and high academic standards!
Get your own paper from top experts
Order nowPerks of our essay writing service
We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.
Frequently asked questions
Get instant answers to the questions that students ask most often.
See full FAQWhat if I’m dissatisfied with the paper I get?
The average quality score at our professional custom essay writing service is 8.5 out of 10. The high satisfaction rate is set by our Quality Control Department, which checks all papers before submission. The final check includes:- Compliance with initial order details.
- Plagiarism.
- Proper referencing.
I need an essay on the same day. Is it something you can do?
Sure. Our writing company offers a fast service with an 8-hour deadline for orders up to master’s level. Make sure to specify the deadline in the order form and our writers will write a paper within the indicated timeslot. Just proceed to submit your requirements here Once you order a custom-written essay, our managers will assign your order to the well-suited writer, who has the best skills and experience for preparing your specific assignment. You can also request one of these extra features:- Choose the Writer’s Samples option – study 3 randomly-provided pages from orders that have been written by the assigned writer.
- Request a specific writer – choose an academic writer from the dropdown list in the order’s form (optional for returning customers).
How can I be sure your writing service is not a scam?
We understand that a shade of mistrust has covered the paper writing industry, and we want to convince you of our loyalty. Apart from high-quality writing services, we offer:- The chances of students to boost writing skills in a quick and effective way.
- The opportunity to manage studies and free time in an enjoyable manner.
- The possibilities to improve overall academic performance.
Is it legal to use your professional writing service?
Yes. Custom writing help is not prohibited by any university or college. It’s a 100% legal way of getting professional assistance with paper writing. Hiring writers from an essay writing company is in many ways similar to consulting a tutor – we help you solve the writing issues at hand.How does your service work?
Our custom writing service is a reliable solution on your academic journey that will always help you if your deadline is too tight. You fill in the order form with your basic requirements for a paper: your academic level, paper type and format, the number of pages and sources, discipline, and deadline. Then, you describe the specific details of the paper you need: add the topic, write or paste the instructions, and attach files to be used, if you have them. After that, an online customer support representative chooses the best writer that specializes in your discipline and assigns him or her to complete the paper according to your requirements. When the paper is ready, we check it for plagiarism and send it to you. If you want to change something, you can request a free revision.