S

@Shivanshu

: Display each employee’s last name, hire date, and salary review date, which is the first Monday after six months of service. Label the column REVIEW. Format the dates to appear in the format similar to “Monday, the Thirty-First of July, 2000.”

SQL
4 years ago
CREATE TABLE EMP(Id integer PRIMARY KEY, FirstName text, LastName text, hire date); INSERT INTO EMP VALUES(1, 'Kamisato', 'Ayaka', 20040923); INSERT INTO EMP VALUES(2, 'Ajax', 'Tartaglia', 20090803); INSERT INTO EMP VALUES(3, 'Xiao', 'Edgelord', 20130315); INSERT INTO EMP VALUES(4, 'Jane', 'Doe', 20080530); INSERT INTO EMP VALUES(5, 'Hu', 'Tao', 20191103); INSERT INTO EMP VALUES(6, 'Rex', 'Lapis', 20010101); INSERT INTO EMP VALUES(7, 'Venti', 'Barbatos', 20150412); INSERT INTO EMP VALUES(8, 'A

Create a query to display the last name and salary for all employees. Format the salary to be 15 characters long, left-padded with the $ symbol. Label the column SALARY.

SQL
4 years ago
CREATE TABLE EMP(Id integer PRIMARY KEY, FirstName text, LastName text, salary integer); INSERT INTO EMP VALUES(1, 'Kamisato', 'Ayaka', 2500); INSERT INTO EMP VALUES(2, 'Ajax', 'Tartaglia', 5000); INSERT INTO EMP VALUES(3, 'Xiao', 'Edgelord', 3300); INSERT INTO EMP VALUES(4, 'Jane', 'Doe', 3500); INSERT INTO EMP VALUES(5, 'Hu', 'Tao', 4000); INSERT INTO EMP VALUES(6, 'Rex', 'Lapis', 7000); INSERT INTO EMP VALUES(7, 'Venti', 'Barbatos', 3700); INSERT INTO EMP VALUES(8, 'Aether', 'Lumine', 7000);

Create a report that produces the following for each employee: <employee last name> earns <salary> monthly but wants <3 times salary>. Label the column Dream Salaries.

SQL
4 years ago
CREATE TABLE EMP(Id integer PRIMARY KEY, FirstName text, LastName text, salary integer); INSERT INTO EMP VALUES(1, 'Akash', 'Verma', 2500); INSERT INTO EMP VALUES(2, 'Lucy', 'Stark', 5000); INSERT INTO EMP VALUES(3, 'Frank', 'Braine', 3300); INSERT INTO EMP VALUES(4, 'Jane', 'Sharma', 3500); INSERT INTO EMP VALUES(5, 'Bharat', 'Tewari', 4000); INSERT INTO EMP VALUES(6, 'Timmy', 'Birds', 7000); INSERT INTO EMP VALUES(7, 'Abdul', 'Shaikh', 3700); INSERT INTO EMP VALUES(8, 'Harish', 'Kumar', 7000)

Write a query in SQL to Display all employee last names in which the third letter of the name is a.

SQL
4 years ago
CREATE TABLE EMP(Id integer PRIMARY KEY, FirstName text, LastName text, salary money); INSERT INTO EMP VALUES(1,'Akash', 'Verma', 45000); INSERT INTO EMP VALUES(2,'Lucy', 'Stark', 50000); INSERT INTO EMP VALUES(3,'Frank', 'Browne', 42000); INSERT INTO EMP VALUES(4,'Jane', 'Sharma', 30000); INSERT INTO EMP VALUES(5,'Bharat', 'Singh', 40000); INSERT INTO EMP VALUES(6,'mohmmad', 'Khan', 34000); INSERT INTO EMP VALUES(7,'Abdul', 'Shaikh', 37000);

Write a query in SQL to display the last name, salary, and commission of all employees who earn commissions. Sort data in descending order of salary and commissions.

SQL
4 years ago
CREATE TABLE emp(id integer primary key, first_name text, last_name text, salary money, commision money); INSERT INTO emp VALUES(1,'harish', 'maxwell', 43324, 231); INSERT INTO emp VALUES(2,'faruk', 'morgan', 63423, 0); INSERT INTO emp VALUES(3,'harsh', 'kohli', 87765, 443); INSERT INTO emp VALUES(4,'alfaiz', 'dhoni', 23424, 323); INSERT INTO emp VALUES(5,'zaid', 'sharma', 63235, 512); SELECT last_name,salary,commision FROM emp where commision != 0 order by salary desc, commision desc;

Write a query in SQL to display the employee number, last name, salary, and salary increased by 15.5% (expressed as a whole number) for each employee. Label the column New Salary

SQL
4 years ago
CREATE TABLE employees ( emp_id INTEGER PRIMARY KEY, last_name TEXT NOT NULL, salary INTEGER NOT NULL ); INSERT INTO employees VALUES (14, 'Heick', 200000); INSERT INTO employees VALUES (23, 'Ven', 3500000); INSERT INTO employees VALUES (7, 'Gin', 500000); INSERT INTO employees VALUES (53, 'Grant', 2500000);

Write a query in SQL to Display the last name of all employees who have both an a and an e in their last name

SQL
4 years ago
CREATE TABLE employees ( emp_id INTEGER PRIMARY KEY, first_name TEXT NOT NULL, last_name TEXT NOT NULL, salary INTEGER NOT NULL ); INSERT INTO employees VALUES (434, 'pranav', 'rajput', 5000000); INSERT INTO employees VALUES (212, 'sristy', 'singh', 3500000); INSERT INTO employees VALUES (151, 'shradha', 'rajlok', 7800000);

Write a query in SQL that prompts the user for a manager ID and generates the employee ID, last name, salary, and department for that manager’s employees. The HR department wants the ability to sort the report on a selected column

SQL
4 years ago
CREATE TABLE employees ( employee_id INTEGER PRIMARY KEY, last_name TEXT NOT NULL, salary INTEGER NOT NULL, department TEXT NOT NULL, manager_id INTEGER NOT NULL ); INSERT INTO employees VALUES (23, 'James', 250000, 'IT',111); INSERT INTO employees VALUES (21, 'Betty', 400000, 'HR',111);

display name except manager

SQL
4 years ago
CREATE TABLE employees ( id INTEGER PRIMARY KEY, last_name TEXT NOT NULL, name TEXT NOT NULL, job TEXT NOT NULL ); INSERT INTO employees VALUES (111, 'McNulty', 'Jimmy', 'manager'); INSERT INTO employees VALUES (222, 'Greggs', 'Kima', 'officer'); INSERT INTO employees VALUES (333, 'Moreland', 'Bunk', 'detective');