SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 2 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 04 Jan 2018 My Price 10.00

department that uses Dell computer, or includes

1. Write SQL SELECT statements for each of the following queries. You need to use the Computer DDL in the assignment folder to create tables in your own database.

1.     How many employees are not using the software package that is over $500?

2.     How many employee use the most expensive computer, in terms of the total cost of software package installed on the computer?

3.     How many software are accounting but are not installed in the accounting department?

4.     List all the information of the software package that has been installed the most (the highest number of installations)

5.     List the name of the department that has more than 3 computers and more than 4 software installed in the last 3 years.

6.     List the name of the department that uses Dell computer, or includes employees whose names are Tracey, or with accounting software installed.

7.     Which manufacturer makes the computer that has the highest total amount of software installed in the last three years?

8.     Which employee does not use the computer that has the highest total amount of software installed in the last three years?

9.     Double the cost of the software package that is the most popular one, defined as the highest number of installations

10. Delete those employees who uses the computer that has accounting software but is not located in the accounting department.

 

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 04 Jan 2018 12:01 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)