Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection (use salaries to restrict the data).
Group employees by salary within their job code: Select the employee's last name and group them by salary within their job_title_code.
Use SQL to make the following changes to the Premiere Products database. After each change, execute an appropriate query to show that the change was made
For each order placed on October 20, 2003, list the order number along with the number and name of the customer that placed the order.
Explain the key concepts that are involved in transaction processing. Define the concepts and provide an explanation of the commands that are involved
Define a view named CustOrder. It consists of the customer number, name, balance, order number, and order date for all orders currently on file
Create a locally-managed tablespace named HANDS_62 with one 10 M OMF datafile in the directory name of your choice.
What is the segment name and extent ID of the table's segment and extent?
Print out the SQL statements and the data from both tables in order to show how the data was affected.
What are the data manipulation capabilities found in SQL Server 2005? Examine the broad range of data manipulation features and provide a summary.
Would the data in the 4th column have much "meaning" or "context" at that point?
Using the order_lines table from the database , write the SQL that will give the Min and Max values of the column "cost_each"
Supply the appropriate SQL Server data types when creating the tables. In the Employee table, create an Employee ID field that will generate a unique number
Use SQL Management Studio to create a database. Be sure to store the database in a location you will remember. Add the tables and data shown below
Write the SELECT FROM WHERE code that will select the row from the authors table
Using the database attached, write scripts in a file to create the following views. I must have a uses clause at the top of the script file
One of the purposes of database tools is to ensure the quality of the Data. What are some trends in Data Quality management that vendors need to pay attention
Defining the dbo.Orders and dbo.Employees tables (Northwind database). The needed query is: List the EmployeeID, LastName, and FirstName of all employees
Create a query with the kudler_team_c database . This query should pull at least two tables together. So it needs to have the following:
Give a list of hire dates of all employees in the following format. The output contains 3 columns so you'll need to select three things.
Find all employees whose name starts with either an S, s, A, a, T, or t. List all information about each employee in the output.
Which employees (by name) have degrees? (the "answer" is Smith, Johnson and Williams)
Design a SQL database that contains the fields found in the company's Chart of Accounts
Use the CREATE DATABASE statement to create a SQL Server database for Kudler Fine Foods.
Write a SQL query that displays the number of people in each EE0-1 Classification and the average salary / hourly wage for each classification.