Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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 Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter8: Advanced Sql
Section: Chapter Questions
Problem 40P
See similar textbooks
icon
Related questions
Question
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 SELECT empname, sal, sal*12 as "Annual Salary" FROM emp; Q4: Show the employees names, salaries, salaries plus commotion for each employees from employee table. SELECT empname, sal, sal+tcommotion FROM emp; Q5: Show the employees names, salaries, annual salaries plus 100$ for each employees from employee table. SELECT empname, sal, (sal*12)+100 FROM emp; Q6: Retrieve the hire date and department number of the employee(s) whose name is “John" WHERE SELECT hiredate, deptno FROM John'; %3D emp empname Q7. Retrieve the name and job title of all employees who work for the department number 10. SELECT empname, job FROM emp WHERE deptno =10 ;
Transcribed Image Text: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 SELECT empname, sal, sal*12 as "Annual Salary" FROM emp; Q4: Show the employees names, salaries, salaries plus commotion for each employees from employee table. SELECT empname, sal, sal+tcommotion FROM emp; Q5: Show the employees names, salaries, annual salaries plus 100$ for each employees from employee table. SELECT empname, sal, (sal*12)+100 FROM emp; Q6: Retrieve the hire date and department number of the employee(s) whose name is “John" WHERE SELECT hiredate, deptno FROM John'; %3D emp empname Q7. Retrieve the name and job title of all employees who work for the department number 10. SELECT empname, job FROM emp WHERE deptno =10 ;
Expert Solution
steps

Step by step

Solved in 2 steps with 7 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
SQL Query
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
SEE MORE TEXTBOOKS