Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
What would my query look like? Although you don't need to build any tables with data, it would help to do this so you can test your sql query.
Find the catalog number, title and category name of all videos
Create a SQL statement to query the COURSE_NAME, CLIENT_NAME, and GRADE from the COURSE, COURSE_ACTIVITY, and CLIENT tables and order the results
Consider the insurance database below, where the primary keys are underlines. Construct the following SQL queries for this relational database.
Using SQL coding, create two tables using the following fields:
List names of the tables that you have created whose name starts with MM. (Hint: use data dictionary view USER_TABLES)
Write a SQL query that joins two tables in the example database and uses LIKE to restrict record selection. Use telephone area codes to restrict data.
An indexed file for the inventory data on disk and its index table are as follows:
Create a query to find the second highest income/salary.
Provide an explicit JOIN SQL statement that returns the store ID, store name, manager employee first and last name fields, manager employee grade
Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. (Use salary to restrict the data.)
Create a SQL query that returns the names of the students (lname, fname), and the major of the major with most students.
Where do you think information about students and tutors such as name, address, phone and e-mail should be kept? Write the necessary SQL commands
Fernando Culebra has always been fascinated by skateboards. Fernando has won several contests, both locally and nationally.
Find the last names, birth dates, and phone numbers of all mechanics who have earned at least $50000 from contracts on Boeing 747 airplanes.
Did the SQL programmer enforce the constraint that every doctor practices in a unique hospital?
Write an SQL statement: To display all the information from the Customer table
Write a SQL statement to display the Major of students with no duplications. Do not display student names.
Create a paper (2-5 pages) that includes your SQL statements and screenshots of the result of your queries in OpenOffice.
Create a report for each of the following requirements. Reports may be created using the wizard or an SQL query. Reports should follow the formatting guidelines
List the name, city, state, and phone number of each customer not located in Washington (state).
Query1 Write a SQL statement to display Students' First and Last Name.
You have been asked to write a SQL statement that will delete ConsumerID 45678.
Create a SQL statements that will retrieve the following data from a database, using Subqueries and Joins.
Create the following tables in the Northwind database: