sql

2.1) In the workers table, list all the information of people whose income is between 5000-8000. 2.2) In the table of workers, all the information of the people whose names are made up of five letters and ends with "y" Type in the SQL code listing. 2.3) In the workers table, list the total salaries by department. 2.4) List the name, surname, salary and premium amounts of the employees receiving premium. 2.5) List the names, premium amounts and parts of all workers who received or did not receive a premium. 2.6) Write the SQL code listing the premium amount of the person whose name is "Roy". 2.7) Update the salary of the person named "Tom" as 7500 in the workers table. 2.8) Update the premium amount of the person whose name is "John" to 9000. 2.9) If the premium amount is not entered in the premium table, it should be entered as 2500 by default. Add the constraint that provides. 2.10) Add the "address" column to the workers table. 2.11) As Ref_id = 6, add the record amounting 3000 dated 01-03-2014 to the bonus table. 2.12) Checking that the E_Id information of the records entered in the bonus table is between 0 and 8 Add the constraint. 2.13) Delete the record with E_Id = 8 from the workers table. 2.14) Delete the Prim_date column from the premium table. 2.15) In the workers table, list the person information consisting of surname letters. 2.16) In the workers table, combine the name and surname information as "the first letter of the name (.) Surname". 2.17) The code of "Tom Jose" that postpones the employment date by 2 years (without using Update) write. 2.18) An employee whose name contains the letter "P" and lists the information of workers whose part is "Insurance". Create the view. 2.19) Create a view that displays the information of the 3 workers with the highest salary. 2.20) Create a view that displays workers with higher than average salary.

Table name:premium Ref_id" | E_ld premium_date premium_amount 1 2 01-02-13 5000 2 3 04-02-13 3000 3 1 01-03-13 4000 4 01-01-13 4500 5 7 01-05-13 3500 1 2. 3 Tablo ad: iler Table name:workers E_id Name Surname Salary Work start date departmant John Abraham 10000 01-01-13 12.00.00 AM accounting Michael Clarke 8000 01-01-13 12.00.00 AM insurance Roy Thomas 7000 01-02-13 12.00.00 AM accounting Tom 6000 01-02-13 12.00.00 AM insurance Jerry Pinto 01-02-13 12.00.00 AM Philip Mathew 7500 01-01-13 12.00.00 AM additional service Tom 123 6500 01-01-13 12.00.00 AM additional sevice Jerry Lname% 6000 01-02-13 12.00.00 AM 4 Jose 5 6500 insurance 6 7 8 insurance