lab 4

create database lab4

CREATE TABLE CUSTOMER
(
CustomerId int IDENTITY(1,1) PRIMARY KEY,
Name varchar(50) NOT NULL,
Age int NOT NULL CHECK (Age >= 18),
Address varchar(200) NULL  DEFAULT  'Dhaka',
Salary decimal(18,2) NULL
)


INSERT INTO CUSTOMER (Name, Age, Address, Salary)
VALUES ('Rahim', 32, 'Gulshan',2000.00),
       ('Karim', 25, 'Dhanmondi',1500.00),
       ('Hashim', 23, 'Mottijheel',2000.00),
       ('Khan', 25, 'Tejgaon',6500.00),
       ('Rahman', 27, 'Wari',8500.00),
       ('Mehedi', 22, 'Mohammadpur',4500.00),
       ('Kashim', 24, 'Kakrail',10000.00),
       ('Kazi', 25, NULL,10000.00)
       SELECT *FROM CUSTOMER



       #1
       SELECT  *  FROM CUSTOMER WHERE SALARY LIKE '200%'

       #2
       SELECT * FROM CUSTOMER WHERE NAME LIKE 'Ka%'

       #3
       select * from CUSTOMER where Age in (25,27) ORDER BY Age

       #4
       SELECT *FROM CUSTOMER WHERE Age BETWEEN 23 AND 27

       #5
       SELECT * FROM CUSTOMER WHERE AGE >= 25 AND SALARY >= 6500

       #6
       SELECT * FROM CUSTOMER WHERE AGE >= 25 OR SALARY >= 6500

       #7
       SELECT * FROM CUSTOMER WHERE NAME LIKE 'Ka%' AND (AGE >= 25 OR SALARY >= 6500)

       #8
       SELECT TOP 3 * FROM CUSTOMER

       #9
       SELECT TOP 60 PERCENT * FROM CUSTOMER

       #10
       SELECT MIN (SALARY) AS Salary,AVG(SALARY) AS TAKA FROM CUSTOMER

       #11
       SELECT MIN(SALARY) AS TAKA FROM CUSTOMER WHERE AGE >= 25

       #12
       SELECT COUNT(*) FROM CUSTOMER WHERE NAME LIKE 'Ka%'


       #13
      SELECT Age ,MAX(SALARY) FROM CUSTOMER GROUP BY Age

      #14
      SELECT Age, MAX(SALARY) FROM CUSTOMER GROUP BY Age  HAVING NAME LIKE 'Ka%'

      #15