create database GA2gouse GA2gocreate table salesman(salesman_id int primary key,name varchar(30),city varchar(20),commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15);insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13);insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11);insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14);insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13);insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12);Create table Customer (customer_id int primary key,cust_name varchar(30),city varchar(10),grade varchar(30), grade varchar(30),salesman_id int,CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES salesman(salesman_id));insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3002, 'Nick Rimando', 'NewYork', 100, 5001);insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3007, 'Brad Davis', 'New York',200, 5001);insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3005, 'Graham Zusi',"California', 200, 5002);insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3008, Julian Green', "London',300, 5002);insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3004, 'Fabian Johnson','Paris', 300, 5006);insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3009, 'Geoff Cameron',"Berlin', 100, 5003);insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3003, 'Jozy Altidor, 'Moscow',200, 5007);insert into customer (customer_id, cust_name, city, grade, salesman_id) values (3001, 'Brad Guzan','London',0, 5005);SELECT s.name,c.cust_name,c.cityFROM salesman sINNER JOIN customer cON s.city = c.city;select sum(commission) as total_commission from salesman;i keep getting this messageMsg 8117, Level 16, State 1, Line 55Operand data type varchar is invalid for sum operator.can you show me what to do

create database GA2 go use GA2 go create table salesman( salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30) ); insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13);

create database GA2 go use GA2 go create table salesman( salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30) ); insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13);

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

Description The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id. +--- | Id | Name | Salary | ManagerId | +---- | 1 | 2 | 3 | 4 +---- | Joe | 70000 | 3 | Henry | 80000 | 4 | Sam | Max Given the Employee table, write a SQL query that finds out employees who earn more than their managers. For the above table, Joe is the only employee who earns more than his manager. + | Employee | + | Joe + | 60000 | NULL | 90000 | NULL I
In Sql Oracle Apex application, Using GROUPING SETS, write a query to show the following groupings:• department_id, manager_id, job_id• manager_id, job_id• department_id, manager_id
DROP TABLE IF EXISTS Worker; CREATE TABLE Worker ( ); 0 INSERT ); WORKER_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FIRST NAME TEXT, LAST NAME TEXT, SALARY INTEGER (15), JOINING DATE DATETIME, DEPARTMENT CHAR (25) INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES 'Arora', 100000, '14-02-20 09.00.00', 'HR'), (001, 'Monika', (002, 'Niharika', 'Verma' 80000, '14-06-11 09.00.00', 'Admin'), 'HR'), 'Admin'), Admin'), 'Account'), 'Kumar', 75000, '14-01-20 09.00.00', 'Account') DROP TABLE IF EXISTS Bonus; CREATE TABLE Bonus ( ); (003, 'Vishal' 'Singhal', 300000, '14-02-20 09.00.00', (004, 'Amitabh 'Singh', 500000, '14-02-20 09.00.00', (005, 'Vivek' 'Bhati', 500000, '14-06-11 09.00.00'. (006, 'Vipul', 'Diwan' 200000, '14-06-11 09.00.00', (007, 'Satish' (008, 'Geetika', 'Chauhan', 90000, '14-04-11 09.00.00', 'Admin'); WORKER_REF_ID INTEGER, BONUS AMOUNT INTEGER(10), BONUS_DATE DATETIME, FOREIGN KEY (WORKER_REF_ID) REFERENCES Worker (WORKER_ID) ON DELETE…
WorksOn Database: Employee (EmployeeNumber, EmployeeName, BirthDate, Title, Salary, DepartmentNumber) Project (ProjectNumber, ProjectName, Budget, DepartmentNumber) Department (DepartmentNumber, DepartmentName, ManagerNumber) WorksOn (EmployeeNumber, ProjectNumber, Responsibility, Hours) Questions: 1) Write an SQL query that returns the project number and name for projects with a budget no greater than $1,050,000. 2) Write an SQL query that returns all works on records where hours worked is less than 5 and the responsibility is 'Manager'. 3) Write an SQL query that returns the employees (number and name only) who have a title of 'EE' or 'SA' and make more than $50,000. 4) Write an SQL query that returns the employees (name and salary only) in department 'D1' ordered by decreasing salary. 5) Write an SQL query that returns the departments (all fields) ordered by descending department name.
Code three tests: 1) for a student who has courses 2) for student who does not have courses 3) a non-existing student ID. For each test, display the value of the student ID that was passed to the function and the result returned by the function. Also, run a supportive SELECT query or queries that prove the test results are correct.
SOQL Assignment: You have to write a SOQL Query In which we have to find all the contact whose accountld is not null and Order the First Name in Descending order.
Create a PL/SQL database programming block with DECLARE BEGIN END; In Declare section define a local scalar (simple) variables. lv_deptno NUMBER And assign initial values as 10 lv_deptno NUMBER := 50; In Declare section again, define a cursor and select last_name, salary and manager_id of employees the ones who are working in the department defined in a) In this example department will be lv_deptno:=50; Sample code: Cursor c_emp as SELECT last_name, salary, manager_id FROM employees WHERE department_id = lv_deptno; In the execution section (BEGIN and END) Create CURSOR FOR LOOP for cursor to process In this cursor loop, your code has to check salary and also manager_id numbers each time new records being fetched. And based on these conditions either employee gets raise or not get raise. If employee salary is less than 5000 and also if employees managers is either 101 or 124 then it means employee is due for raise otherwise employee is not due for raise Sample…
Employee(empno, ename, street, city, mgrssn) work_project(eno, pno, number_of_hours) Write a query and optimize it to find employee name and project number in which they work and who live in "New_york". Identify the type of indexing to be applied on 'empno' in Employee Table.
SQL: Create a SQL query that uses an uncorrelated subquery and no joins to display the descriptions for products provided by a vendor in area code 615. Remember, the main difference between a correlated subquery and uncorrelated subquery is that, in a correlated subquery, the inner query is dependent upon the outer query, while, with an uncorrelated query, the inner query does not depend upon the outer query. Instead, it runs just once. You should NOT use union, minus, or intersect in this query. The outer query will use the PRODUCT table and the inner query will use the VENDOR table [hint: you should have 9 records of output]. My code: select p_descript from product where (select v_areacode from vendor where v_areacode = '615' ; I am getting this error, problem is I can't see what is missing any assistance is appreciated. ORA-00936: missing expression
select * from cast where cast_id=162652763; Use explain to display the query plan without creating any index. Now create an index to speed up the query. Use explain and timer to show the improvement.
True or False below: Given two relations named A and B, if we q-JOIN A and B, the maximum number of attributes in the result relation could be (the number of attributes of A) times(*) the number of attributes of B). * in an SQL SELECT statement means “all the tuples”. In relational algebra, Cartesian Product (X) can be implemented using the q-JOIN operator. Cartesian Product ISA q-JOIN where q-condition always evaluates to true. SQL is based on Predicate Calculus. A query in SQL always specifies what should be included in the query result.
Draw the ERD rI : ithat is implemented by the following SQL code: CREATE TABLE PROJ_USER USER_ID NUMBER NOT NULL, USER_NAME VARCHAR2(50) NOT NULL, USER_EMAIL VARCHAR2(50) NOT NULL, CONSTRAINT USER_PK PRIMARY KEY (USER_ID) ); CREATE TABLE PROJ_CERTIFIEDUSER USER_ID NUMBER NOT NULL, CUSER_REALNAME VARCHAR2(50) NOT NULL, CUSER_CERTIFICATION VARCHAR2(50) NOT NULL, CONSTRAINT CERTIFIEDUSER_PK PRIMARY KEY (USER_ID), CONSTRAINT CERTIFIEDUSER_FK FOREIGN KEY (USER_ID) REFERENCES PROJ_USER (USER_ID) );