Create a View to display the employee id, first name and surname. In your query include the coin price and a 10% commission for the sales made by the employees. Sample Output: EMPLOYEE_ID FIRST_NAME SURNAME COIN_PRICE |COMMISSION Samson R 2599.8 emp105 Xolani R 25998 emp102 Steven Marks R 17998 R1799.8 emp101 Xander Davis R 20998 R 2099.8 emp103 Jessica Andrews R 17998 R 1799.8

Create a View to display the employee id, first name and surname. In your query include the coin price and a 10% commission for the sales made by the employees. Sample Output: EMPLOYEE_ID FIRST_NAME SURNAME COIN_PRICE |COMMISSION Samson R 2599.8 emp105 Xolani R 25998 emp102 Steven Marks R 17998 R1799.8 emp101 Xander Davis R 20998 R 2099.8 emp103 Jessica Andrews R 17998 R 1799.8

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

2) Create a SELECT statement that returns the count, average, max and min of the invoices submitted by each vendor, who has submitted more than one invoice. Order by the number of invoices in descending order. Should return 12 rows. number of vendor name average_invoice_total min_invoice_total max_invoice_total invoices Federal Exoress Corporation United Parcel Service 47 93.15 10.00 739.20 2575.33 1927.54 3813.33 Zvlka Desian Pacific Bel Malov Lithoarachina Inc 313. 55 16.33 867.53 1962. 13 28.50 46.21 23978.48 10976.06 37966, 19 25.67 224.00 Roadwav Packaoe Svstem. Ic 4 10.92 6.00 Blue Cross Comouserve Incram Data Reoroductions Corp IBM |Cardinal Business Media. Inc. 188.00 116.00 9.95 9.95 9.95 2 1077.21 579. 42 1575.00 85.31 116.54 10963.66 21842.00 600.06 132.68 1083. 58 90.36 175.00
1. Create the My Employee table with the following fields: Not Null ID Last Name First Name Userid Salary 1 2 3 4 5 2. Add the constraint Primary Key (ID) to the table. 3. Insert the following data to the table: ID Last Name First Name Ali Number(4) Varchar(25) Varchar(25) Varchar(8) Number(9,2) AlChameri Alanizi Hejazi Turki AlKamel Rayen Decham Mohamed Fahhed Userid raptel bdancs bbiri cnewman aropebur Salary 795 860 1100 750 1550 I 4. Select all the data in the table. 5. Change the Last Name of employee 4 to Turkish. 6. Change the Salary to 1000 for all employees with a salary less than 900
SQL LANGUAGE PLEASE JUST ANSWER WITHOUT EXPLANATION
WEEK 1 ASSIGNMENT Complete the following exercise: Create a student table. The student table needs to include the following columns: Student ID Student First Name Student Last Name Middle Name City State ZIP Code GPA Use the appropriate data types for each column. Create a Primary Key constraint for the table. Make sure all columns contain either a NULL or NOT NULL constraint.
Guest details and Total Charges paid Display guest details who paid total charges RS.50000 and above. Write a query to fetch Guest id, Guest name and Sum of total charges. Give alias name to total charges as TOTALPAID. Sort the result by guest id. RESORT MANAGEMENT SYSTEM Pointofinterest Town Manager PK pointiD Number PK towniD Number PK manageriD Number townname Varchar(30) describe Varchar(30) name varchar(30) varchar(30) varchar(30) + varchar(30) state opentime varchar(10) address varchar(30) longitude latitude city varchar(20) closetime varchar(10) phone varchar(15) FK townID Number summertemp Number wintertemp Number sealevel Number Resort Guest Review PK resortiD Numbes gasanb Number varchar(30) PK guestiD FK.PK guestID Number resortName varchar(30) name FK.PK resortiD Number varchar(30) street ANAES address varchar(30) ++ dateofreview Date townname varchar(30) varchar(20) varchar(30) country email comments varchar(150) FK townid Number phone varchar(15) starRating Number FK…
MS-ACCESS (. 1. Create a database COMPANY and create a new table EMPOLYEE and name it 2. Design a table EMPOLYEE so that it has all fields and the following properties FIELDS DATATYPE PROPERTIES EMPNO Number 4 EMPNAΜΕ Short Text 10 PHONE Number 8 PLACE Short Text 9. DOJ Date/Time 3. Set the field EMPNO as the primary key and save the table 4. Enter the following data into the table EMPLOYEE EMPNO ΕMPNAΜΕ PHONE PLACE DOJ 1111 ΑΗMED 98989898 | IBRI 12/06/2014 2222 SARA 99997777 | NIZWA 15/09/2018 3333 AMNA 90909090 | MUSCAT 14/06/2017 4444 NAHID 91919191 IBRI 02/08/2015 5. Design a table SPORTS so that it has all fields and the following properties FIELDS DATATYPE PROPERTIES EMPNO Number 4 SPORTS Short Text 10 YEARS Number 2 SCHOLARSHIP YES/NO AMOUNT CURRENCY 6. Set the field EMPNO as the primary key and save the table 7. Enter the following data into the table SPORTS EMPNO SPORTS YEARS SCHOLARSHIP AMOUNT 4444 FOOTBALL YES 50 3333 BASKETBALL NO 2222 FOOTBALL 1 NO 1111 CRICKET YES 50 8.…
10) The query used to list the C_CODE, C_MAKE, C_DATE, and C_PRICE fields from the Cars table in ascending order by C_PRICE is a. SELECT C_CODE, C_MAKE, C DATE, C_PRICE FROM Cars SEQUENCE BY C_PRICE; b. SELECT C_CODE, C_MAKE.C DATE, C_PRICE FROM Cars LIST BY C_PRICE; c. SELECT C_CODE, C MAKE, C DATE, C PRICE FROM Cars ORDER BY C_PRICE; d. SELECT C_CODE, C_MAKE, C_DATE, C_PRICE FROM Cars
Question 2 Write a query to display the last name, job, and salary of all employees whose salaries are less than 10,000 or greater than 15,000 Expect the output of your query to be similar (not necessarily identical) to the following: LNAME JOB SALARY Porter Jalal Sagr Alrashidi Hamdan Kamaleldeen 6 rows selected. CEO HR Officer Accountant PR Programmer Accountant 22000 6500 6880 5000 8750 5750
CREATE TABLE employees8(employee_id NUMBER(10) PRIMARY KEY,first_name VARCHAR(25) UNIQUE,last_name VARCHAR(25) UNIQUE,job_id NUMBER(3),salary NUMBER(6) NOT NULL,department_name VARCHAR2(20));CREATE TABLE jobs8(job_id NUMBER(3) PRIMARY KEY,job_title VARCHAR2(25),min_salary NUMBER(4)check(min_salary >=2900),max_salary NUMBER(6)check(max_salary<=100000)); CREATE TABLE departments8(department_id NUMBER(2) PRIMARY KEY,department_name VARCHAR2(30),location_name VARCHAR2(15) DEFAULT 'Istanbul'); how can I do this question according to these 3 tables ? Create a complex view that joining with three tables.
Use the code below to write a query to display the movie title, movie year, and movie genre for all movies CREATE TABLE MOVIE ( MOVIE_NUM NUMBER(8,0) PRIMARY KEY, MOVIE_TITLE VARCHAR2(75) NOT NULL, MOVIE_YEAR NUMBER(4,0) CHECK (MOVIE_YEAR > 1900), MOVIE_COST NUMBER(5,2), MOVIE_GENRE VARCHAR2(50), PRICE_CODE NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE ); INSERT INTO MOVIE VALUES (1234, 'The Cesar Family Christmas', 2011, 39.95, 'FAMILY', 2); INSERT INTO MOVIE VALUES (1235, 'Smokey Mountain Wildlife', 2008, 59.95, 'ACTION', 1); INSERT INTO MOVIE VALUES (1236, 'Richard Goodhope', 2012, 59.95, 'DRAMA', 2); INSERT INTO MOVIE VALUES (1237, 'Beatnik Fever', 2011, 29.95, 'COMEDY', 2); INSERT INTO MOVIE VALUES (1238, 'Constant Companion', 2012, 89.95, 'DRAMA', NULL); INSERT INTO MOVIE VALUES (1239, 'Where Hope Dies', 2002, 25.49, 'DRAMA', 3); INSERT INTO MOVIE VALUES (1245, 'Time to Burn', 2009, 45.49, 'ACTION', 1);
4. How many customers do we have with a last name starting with a 'Q' living in each city? Your query should display two columns, one named cust_num and one named city. Sort the results alphabeticaly by city. 5. Show the product name, list price, customer state (call it 'CustState'), and manufacturer state (call it 'ManState') for all products made by manufacturers in Connecticut (CT) and purchased by customers in New York (NY). 6. For green sandals, how does the current list price compare to the price at which products have sold? Show the product name, the 7. What is the total number of products sold by each manufacturer? Your query should display two columns, one named productnum and one named manufacturername. Sort the results alphabetically by manufacturername.
Use departments. Create a query to display all the data from that table as one column. Separate each data value by a \ and add the \ at the start and end of the output row. Display the results in descending order of location id, and alpha order of department name within location id. Name the column title THE DEPARTMENTS OUTPUT.Ex: \20\Marketing\201\1800\