Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Write a code to add two rows of data to the table that was created using the command above. Ensure the default option on the LAST_DATE column
Using the two tables above, write an SQL statement that uses a SUB QUERY and the IN keyword to return the First Name of the customers who live in the state
Using the updated database, write the following queries using the SQL GROUP BY statement and appropriate aggregate statements (when needed):
Write a SQL statement to display the SKU and Description of all items stored in the Seattle, Chicago or New Jersey warhouse. Do not use IN.
Create the following queries on the attached database .Remember to define what database to use with a USE statement.
List all the employees in the emp table. If they work for department Accounting, then add 1200 to their salary.
Write a SELECT statement that lists the StudentID, FirstName, LastName, and GPA of freshman (FR) whose GPA is 3.5 or higher. Use only the Student table.
Using the database, tables, and data, write SQL statements to:
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