MYSQL SOLUTION

QUERY SOLUTION

CREATE DATABASE

CREATE TABLE STAFF and INSERT ALL THE RECORD. 

SOL1  :- Display the difference of maximum and minimum salary of each section.

SOL2 :- Display the staff name, designation and date of joining who joins in the month of July and April. 

SOL3 :- Display the records of staff in their descending order of salary. 

SOL4 :-  Show first 3 character of staff name.

SOL5 :- Display the records of staff who is working since last 12 years

SOL6 :- Display power of length of staff name

Leave a Reply

Your email address will not be published. Required fields are marked *

sign up!

We’ll send you the hottest deals straight to your inbox so you’re always in on the best-kept software secrets.