Preview

Sudhakar

Satisfactory Essays
Open Document
Open Document
1718 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Sudhakar
CHAPTER- MySQL Lab exercise
1. Consider the following table named "GYM" with details about Fitness products being sold in the store.
Table Name: GYM
PrCode stores Codes of Products
PrName stores names of Products
(UnitPrice is in Rs.)
PrCode
PrName
UnitPrice
Manufacturer
P101
Cross Trainer
25000
Avon Fitness
P102
TreadMill
32000
AG Fitline
P103
MassageChair
20000
Fit Express
P104
Vibration Trainer
22000
Avon Fitness
P105
Bike
13000
Fit Express

Write SQL statements to do the following:
a) Display the names of all the products in the store.

b) Display the names and unit price of all the products in the store

c) Display the names of all the products with unit price less than Rs.20000.00

d) Display details of all the products with unit price in the range 20000 to 30000

e) Display names of all products by the manufacturer "Fit Express"

f) Display all rows sorted in descending order of unit price.

g) Add a new row for product with the details: "P106","Vibro Exerciser", 23000, manufacturer: "Avon Fitness".

h) Change the Unit Price data of all the rows by applying a 10% discount reduction on all the products.

i)Display details of all products with manufacturer name starting with "A"

2. Consider the following tables Employee and Department. Employee
Ecode
LastName
FirstName
Department
101
Sharma
Amit
Sales
102
Arora
Shiv
Personnel
103
Lakshmi
KS
Accounts
104
Rajlani
Shivika
Accounts
105
Thakral
Satvik
Sales

Department
DepCode
DepName
Budget
101
Sales
200000
102
Personnel
150000
104
Accounts
300000 Write SQL statements to do the following:

a) Display the last names and first names of all employees.

b) Display the Department names of all employees, without duplicates.

c) Display all the details of employees with last name as "Lakshmi".

d)

You May Also Find These Documents Helpful

  • Good Essays

    Fast Fit Case 1-6

    • 1718 Words
    • 7 Pages

    B. What are three important uses of this information at the store by the store…

    • 1718 Words
    • 7 Pages
    Good Essays
  • Good Essays

    1. Use a table to identify the software products sited above that fall within the following categories of software:…

    • 636 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Task 1: Compile two tables one for each type of business and discuss their purpose and ownership of each of two contrasting businesses.…

    • 3737 Words
    • 15 Pages
    Powerful Essays
  • Satisfactory Essays

    Pride Case Study

    • 486 Words
    • 2 Pages

    7-6. The Store Exercise prescription application uses the data from the tables in figure 7-17 to display information to a client application that can be accessed and used by healthcare professionals to help them prescribe the appropriate workout for particular patients.…

    • 486 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    unit2assignment

    • 757 Words
    • 4 Pages

    P1: Complete a table like the one below to show the types, sources and purposes of information used within the organisation. Try to include at least two examples of each type of information.…

    • 757 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    NISHAN KARKI

    • 1407 Words
    • 15 Pages

    Conc. Elective: Biol 315 (Sp only), 328 (Sp only), 329 (Sp only), 332 (Sp only), *421, 475…

    • 1407 Words
    • 15 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Bosu Trainer

    • 317 Words
    • 2 Pages

    4. In 2004, Fitness quest had alliances with trainers and its main competitor had allinaces with major retailer. Thus , both companies were competing on the basis of their alliances. Why do you think Fitness Quest won this competition? To what extent did its success in leveraging relationships with trainers depend on information systmes. On other factors?…

    • 317 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    a. Three ways that determined these products and/or services would be the most feasible and potentially profitable for the company to add are:…

    • 2368 Words
    • 7 Pages
    Good Essays
  • Good Essays

    Athabasca Assignment

    • 837 Words
    • 4 Pages

    For this assignment, you will be analyzing the data in a simple, one-table database by creating queries and reports in Microsoft Access. The system you are “developing” will be used by The Queen’s Inn in St. John’s, Newfoundland for strategic business development purposes.…

    • 837 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    The incorrect data entered, or the software error of the system can cause the wrong result.…

    • 396 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    4. A company has an office complex with athletic fields, a gym, a large garden, and a large picnic…

    • 682 Words
    • 3 Pages
    Powerful Essays
  • Powerful Essays

    SQL: Queries

    • 6089 Words
    • 25 Pages

    SQL-QUERIES 1. Display all the information of the EMP table? A) select * from emp; 2. Display unique Jobs from EMP table? A) select distinct job from emp; B) select unique job from emp; 3. List the emps in the asc order of their Salaries? A) select * from emp order by sal asc; 4. List the details of the emps in asc order of the Dptnos and desc of Jobs? A)select * from emp order by deptno asc,job desc; 5. Display all the unique job groups in the descending order? A)select distinct job from emp order by job desc; 6. Display all the details of all ‘Mgrs’ A)Select * from emp where empno in ( select mgr from emp) ; 7. List the emps who joined before 1981. A) select * from emp where hiredate < (’01-jan-81’); 8. List the Empno, Ename, Sal, Daily sal of all emps in the asc order of Annsal. A) select empno ,ename ,sal,sal/30,12*sal annsal from emp order by annsal asc; 9. Display the Empno, Ename, job, Hiredate, Exp of all Mgrs A) select empno,ename ,job,hiredate, months_between(sysdate,hiredate) exp…

    • 6089 Words
    • 25 Pages
    Powerful Essays
  • Satisfactory Essays

    6. Display the list of all the orders placed on June 06, 2004. (Use the…

    • 874 Words
    • 6 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Kanswal

    • 356 Words
    • 2 Pages

    FORM - XXIV Department of Commercial Taxes, Government of Uttar Pradesh [See rule-45(2) of the UPVAT Rules, 2008] Return of Tax Period - monthly / quarterly [To be filled in block letters only] | |Assessment Year | |a- |Vat Goods | | |Purchase against tax invoice (annexure-A) | | |Purchase from registered dealers | |Sl. No. |Rate of tax |Commodity |Turnover of Purchase |Tax | | |Vat Goods | | | | |1% | | | | | |4% | | | | | |12.5% | | | | | |Total | | | | |Non Vat Goods | | | | |20% | | | | | |21% | | | | | |26% | | | | | |32.5% | | | | | |--- | | |…

    • 356 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    DOCUMENTS

    • 435 Words
    • 3 Pages

    Select the AdventureWorks2012_Data.mdf database file and click OK. If the file is not listed, check the C:\Program…

    • 435 Words
    • 3 Pages
    Satisfactory Essays

Related Topics