Question

Create a table MEGATECH with the following table structure in My SQL :

ENO CHARACTER 4 PRIMARY KEY

ENAME CHARACTER 20

DESIGNATION CHARACTER 25

DOJ DATE

SEX CHARACTER 1 ‘M’ or ‘F’

SALARY NUMBER 7 2 >20000 AND < 80000

CITY CHAR 30 NOT NULL

Insert 5 rows in it with the following data .

Eno EName Designation DOJ Sex Salary City

1321 Nanda Manager 6/6/95 M 55100 Agra

1432 Saurabh Asst Manager 7/5/93 M 46200 Mumbai

1566 Sanal Asst Manager 6/5/94 F 40000 Delhi

1765 Trisla Head Cashier 8/8/95 F 45000 Mumbai

1888 Santosh Senior Clerk 8/10/95 M 36900 Delhi

2011 Marisla Junior Clerk 12/12/94 F 25000 Dubai

1298 Neha Accountant 8/12/95 F 37700 Moscow

2089 Nishant Dy.Manager 12/6/95 M 48900 Moscow

Execute the following SQL commands

i. Display the total number of employees of each city.

ii. Display the name of the employee with the maximum salary.

iii. Display the details of all employees whose name starts with ‘A’.

iv. Display the details in descending order of Eno.

v. Display the Different designations.​

Answer 1

Answer:

(Demand?

Price elasticity of demand is a measurement of the change in consumption of a product in relation to a change in its price. Expressed mathematically.