Write each of the following queries in SQL: 1. Create the table Computer. 2. Create the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Write each of the following queries in SQL: 1. Create the table Computer. 2. Create the table employee. 3. Retrieve the cpu, the memory, and the price of all computers in the TechShop. 4. Retrieve the name of all employees with salary greater than 1000 5. Retrieve the serial number of all computers that haven't been sold yet 6. Retrieve the ssn of employees who sold a computer with "core i7" cpu 7. Retrieve the names of all employees who sold a computer 8. Add a new column (hdd) to the computer table. The value of hdd represents the capacity of the hard disk 9. Add new computer to the database with the following values: serialNb=112233, cpu=core i5, memory%3D32, price=1000 10.For all computers with cpu "core i5", increase the price by adding 10 to it. 11.Remove the employee with ssn 445566 from the employee table 12.Can we Remove the table employee from the database and how ? Write each of the following queries in SQL: 1. Create the table Computer. 2. Create the table employee. 3. Retrieve the cpu, the memory, and the price of all computers in the TechShop. 4. Retrieve the name of all employees with salary greater than 1000 5. Retrieve the serial number of all computers that haven't been sold yet 6. Retrieve the ssn of employees who sold a computer with "core i7" cpu 7. Retrieve the names of all employees who sold a computer 8. Add a new column (hdd) to the computer table. The value of hdd represents the capacity of the hard disk 9. Add new computer to the database with the following values: serialNb=112233, cpu=core i5, memory%3D32, price=1000 10.For all computers with cpu "core i5", increase the price by adding 10 to it. 11.Remove the employee with ssn 445566 from the employee table 12.Can we Remove the table employee from the database and how ?
Expert Answer:
Answer rating: 100% (QA)
Long Computer Sen aliNb varchail255 CREATE TABLE vai... View the full answer
Posted Date:
Students also viewed these databases questions
-
Write each of the following in exponential form. a. log2 32 = 5 b. log3 1/81 = -4 c. log10 10 = 1 d. ln e2 = 2
-
Write each of the following without using logarithms. a. loga x + loga y - mz = 0 b. ln a - ln b + xy = 0
-
Capacity management, denominator-level capacity concepts. REQUIRED Match each of the following numbered items with one or more of the denominator-level capacity concepts by putting the appropriate...
-
Explain the difference between product placement & branded entertainment . Do you personally notice product placements in television shows or movies? Why or why not? Identify at least two factors...
-
Give an example, other than those presented in this section, of a a. Qualitative variable. b. Discrete, quantitative variable. c. Continuous, quantitative variable.
-
How would a policy of mandatory vacations have helped discover the Beta fraud?
-
Consider a binomial model with three dates as introduced at the end of Sect. 6.3 (with \(t \in\{0,1,2\}\) ) and a contingent claim with payoff \(f\left(s_{2} ight)\), where \(s_{2}\) denotes the...
-
A commercial fisherman notices the following relationship between hours spent fishing and the quantity of fish caught: Hours Quantity of Fish (in pounds) 0 hours ......0 lb 1.........10 2.........18...
-
- The market value of the assets in the plan as of January 1 , 2 0 2 3 was $ 1 , 9 8 2 , 6 0 0 ; - The Company ABC contributes the normal cost for 2 0 2 3 on June 3 0 , 2 0 2 3 ; and - The pension...
-
A sinusoidally modulated ordinary AM waveform is shown below. -3 (a) Determine the modulation index. (b) Calculate the transmission efficiency. (c) Determine the amplitude of the carrier which must...
-
If a ligament is stretched by 0.034m and has a stiffness constant of 10,000N/m, how much strain energy is produced?
-
Discuss the following: a. Speaking positively, it might be said that accrual accounting improves on the cash flow information. Speaking negatively, it might be said that accrual accounting messes up...
-
Some other information related to the year ended 30 June 2016: a. Credit sales, $130 000. b. Purchase of inventory on credit, $70 000. c. No dividends were declared or paid. Required: 1. What was...
-
At the beginning of 2015, SD Corporation acquired machinery that cost $100 000 and had an anticipated useful life of 10 years. SD Corporation depreciated this machinery for 2015 and 2016, using the...
-
The following transactions occurred for Gilchrest Ltd (assume all beginning balances = 0) during the year ended 31 December 2016. a. Issued shares for $700 000 cash. b. Signed a contract on 1 October...
-
Courier Service Limited is engaged in the delivery of parcels in the city and suburbs. Ten light vans are used and, in addition to the manager and 10 drivers, two people are employed in the office....
-
Where a work refusal shuts down an assembly line, and puts many workers out of work while it is being adjudicated: The federal legislation (CLC II) is silent on this issue The Ontario legislation is...
-
A woman at a point A on the shore of a circular lake with radius 2 mi wants to arrive at the point C diametrically opposite on the other side of the lake in the shortest possible A time. She can walk...
-
20 East 67th Street Associates LLC (Landlord) is the owner of a seven-story residential property located at 20 East 67th Street in Manhattan, New York (the Property). On January 2, 2019, Emily Jerome...
-
A landlord appeals and a tenant cross-appeals a district court ruling affirming in part and reversing in part a small claims court decision in a residential landlordtenant dispute. This is a case...
-
Norman Eastwood owns and lives in a single-family home with his wife (the Property). The Property is located in the Willow Bend Lakes Community in Plano, Texas. The Willow Bend Lakes Community is...
Study smarter with the SolutionInn App