SQL DML Simple Select Statements from a single table Homework Name_
Write the SQL statements that would be used to query the following data.
Bring back all of the columns from the table QTR for the team DallasCowboys.
2. Bring back names and yards of a
Database Homework: Aggregate Functions, Nested Queries, Union, Intersect, Except
Write the SQL code for the following queries (you do not have to give the results of the query)
1. List the employee id and sum of days duration for employees that have
How to get to the enterprise database systems we will be using:
From an ATU computer with VMware vSphere Client installed:
Find and Open "VMware vSphere Client"
The IP address box should have the follolwing IP address: 10.20.8.20
In the user name box type
EMPLOYEE Table: (Every row is for a different employee, each column provides information about that employee)
FNAME=First Name, MINIT=Middle Initial, LNAME=Last Name, SSN=Social Security Number (can be used in a join to any of the social security numbers
1. Find the average number of running backs per team. (First create a derive table by going to the
RB table and counting the number of running backs per team, then take the average).
2. Find the number of employees by department in the sup
Extra Database Practice
Notes: = versus an IN
WHERE team = (SELECT team
WHERE team IN (SELECT team
If an equal sign is used
Database In-class SQL practice, use the following tables to write the requested SQL queries (dont give the answer, just
the SQL queryalso dont hardcode values in, use subqueries, joins, etc.).
Database SQL Assignment 3 JOINs
Give the SQL query (you do not need to give the result of executing the query), each query must contain at least one
1. Display the employee titles whose department is located in a secret cave.
2. Display the ti
Sains Malaysiana 41(8)(2012): 10291035
Effect of Different TiO2 Preparation Techniques on the Performance of the
Dielectric Bolometer Ba06Sr0.4TiO3 as a Distance Sensor
(Kesan Kaedah Penyediaan TiO2 yang Berbeza Terhadap Prestasi Bolometer Dielektrik
NIH Public Access
Nano Lett. Author manuscript; available in PMC 2010 December 1.
NIH-PA Author Manuscript
Published in final edited form as:
Nano Lett. 2009 December ; 9(12): 41474152. doi:10.1021/nl902368r.
Simple, Rapid, Sensitive, an
View Article Online / Journal Homepage / Table of Contents for this issue
Dynamic Article Links <
Cite this: J. Mater. Chem., 2011, 21, 3415
One step hydrothermal synthesis of TiO2-reduced graph