Q1: Show all the information from the employee table.SELECT * FROM emp;Q2: Show the employees names and numbers from employee table.SELECT empname, Empno FROM emp;Q3: Show the employees names, salaries and their annual salariesfrom the employee table, name the last field by annual salary.SELECT empname, sal, sal*12 FROM emp;Or we can change the attribute name using asSELECT empname, sal, sal*12 as "Annual Salary" FROM emp;Q4: Show the employees names, salaries, salaries plus commotionfor each employees from employee table.SELECT empname, sal, sal+tcommotion FROM emp;Q5: Show the employees names, salaries, annual salaries plus 100$ foreach employees from employee table.SELECT empname, sal, (sal*12)+100 FROM emp;Q6: Retrieve the hire date and department number of theemployee(s) whose name is “John"WHERESELECT hiredate, deptno FROMJohn';%3DempempnameQ7. Retrieve the name and job title of all employees who workfor the department number 10.SELECT empname, job FROM emp WHERE deptno =10 ;

The select statement is used to select a value from the database. The selected columns are displayed…

Q1: Show all the information from the employee table. SELECT * FROM emp; Q2: Show the employees names and numbers from employee table SELECT empname, Empno FROM emp; Q3: Show the employees names, salaries and their annual salaries from the employee table, name the last field by annual salary. SELECT empname, sal, sal*12 FROM emp; Or we can change the attribute name using as

Q1: Show all the information from the employee table. SELECT * FROM emp; Q2: Show the employees names and numbers from employee table SELECT empname, Empno FROM emp; Q3: Show the employees names, salaries and their annual salaries from the employee table, name the last field by annual salary. SELECT empname, sal, sal*12 FROM emp; Or we can change the attribute name using as

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

Name an example of an attribute in the following table. Student_ID Student Name Student Street Address 4411 Ramona Garrett 233 POOL Alley 3068 Roberto Mendoza 73192 KENSINGTON Rd. 4383 Bradley Pierce 93691 SOLIDARITY Rd. 4975 Leigh Freeman 63759 EASTGATE Rd. 4799 Candace Washingtoi 6144 POOL Dr.
Task 1: ' The Car Maintenance team wanted to ensure that the default price of the maintenance actions should not be empty and 0 instead if not specified. Alter the MAINTENANCE_TYPES table created in Chapter 8, Activity 1 to set the default MAINTENANCE_PRICE to 0. ANSWER IN MYSQL PLEASE
The Driver Relationship team wants to ensure that the all driving license IDs in the active drivers table have the length of 7. Alter the ACTIVE_DRIVERS table created in Chapter 8, Activity 1 to check the length of the DRIVER_DRIVING_LICENSE_ID.
I need help with the SQL query for the following question: 1. Get a list of 5 reviews for shoppers in Chicago Here is the information on the field names: The table name is: Reviews Review Form Fields Product/ModelName: Product/Category: Product/Price: Retailer/Name: Retailer/ZipCode: Retailer/City: Retailer/State: Product/On Sale: Manufacturer/Name: Manufacturer/Rebate: Review/UserId: Review/Rating: Review/Date: Review/Text: Example of Review Form Filled out ProductModelName: Galaxy S4 ProductCategory: Smart Phone ProductPrice: 499 RetailerName: Bestbuy RetailerZipCode: 44114 RetailerCity: Cleveland RetailerState: OH ProductOnSale: No ManufacturerName: Samsung ManufacturerRebate: No ReviewUserId: xmm473 ReviewRating: 3 ReviewDate: 6/10/2012 ReviewText: overheats after 2 hours
Using the Categories, Subjects, and Classes tables, list the category description, SubjectID, SubjectCode, and SubjectName for all subject that are taught on Wednesdays. Do not list any subject more than once.
Given the table PRODUCT(ProductID, ProductName, ProductClass, ProductWeight, ProductStyle, ProductColor, ProductPrice). Note: ProductWeight and ProductPrice are numeric fields, and the other attributes are character fields, i.e., store text. Write a SQL query to display the product class whose average price is at least 50
8. The head of the hospital’s accounting department is concerned about the prescribed charge for services versus the actual charges for services in the surgery category of services (service_cat_id = ‘SUR’). Produce a listing of surgery services listed in the treatment table by service_id where the prescribed service_charge differs from the actual_charge recorded in the treatment table. The result table should also include the service_charge and actual-charge. Use a subquery approach to produce a listing of service_id values from the service table that belong to the ‘SUR’ category of services. Display the result table with the service and actual charges formatted to include the dollar sign ($)
Refer to the dimension tables and EmployeeFact table below. Job Date Location EmployeeFact •JobID •DatelD •LocationID • ( OEmployeelD Title FullDate StreetAddress oJobID JobCode DayNumber City PostalCode OLocationID LevelCode MonthNumber oHireDatelD OBirthDatelD ) SalaryAmount BonusAmount MonthName State Year CountryCode EducationYears PerformanceRating The following query reports the employee with the highest salary amount per postal code for employees with level code 8. Complete the missing values. SELECT CountryCode, EmployeeID, MAX(_ _(A)_ FROM (B). Location, Job WHERE EmployeeFact.LocationID = Location.LocationID AND EmployeeFact.JobID = (C). AND = 8 GROUP (A) Ex: Identifier (B) (C)
The StayWell maintenance team wants to minimize the number of planned visits to properties. The team wants to learn all the properties that have different planned service dates. You need to return all available data in the SERVICE_REQUEST table, where requests are made for the same property with a different NEXT_SERVICE_DATE. Return a list of all properties where service requests are made with different NEXT_SERVICE_DATE values.
convert it to relations that are normalization
8. The head of the hospital’s accounting department is concerned about the prescribed charge for services versus the actual charges for services in the surgery category of services (service_cat_id = ‘SUR’). Produce a listing of surgery services listed in the treatment table by service_id where the prescribed service_charge differs from the actual_charge recorded in the treatment table. The result table should also include the service_charge and actual-charge. Use a subquery approach to produce a listing of service_id values from the service table that belong to the ‘SUR’ category of services. Display the SQL code written
Use your ERD to define the table structures in the database using SQL DDL commands to build your schema.