Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
Write stored procedure that implements the processing when a DVD is returned in the mail from a customer and the next DVD is sent out.
Find the number of students in each major. Find the number of employees in each department who get no commission or have salary less than 5000.
What are brand names of ALL teal cars? Names of dealers who sell some purple car OR are in Dallas? Names of dealers who sell some green car AND are in Atlanta?
What you have learned up to now (need to have a user-defined function at minimum). Make sure to use try/exception to avoid code-breaking.
What are three categories of SQL language? Describe each category in detail. What is Web-based Programming that we discussed in the class?
How do you assign this kind of privilege (only see rows with letters starting with D) to the role without using views?
Write a routine claim email to Rodney Harding, Marketing Manager, Big Spruce Wood Products. List at least three things that you do not like about the desk.
How do you believe communication for the business world will change in the next year? Social media changed how we communicate to each other.
List the employee ID and employee name for those employees who do not possess the skill Router. Display the results in order by EmployeeName.
Question: Explain the term "Schemaless" in NoSQL and provide one example.
Write a single SQL query that lists, for each decade, the name of the decade (in the format detailed below) and the title and rating of the highest rated movie
List an SQL statement to create a user with the username, northwind, and allow the user to connect to the server from any host.
Write a SQL query that shows OrderID, OrderDate, ProductID, Quantity where the quantity is between 40 and 50. (HINT JOIN Orders and OrderItem table)
1. List the customers who ordered computers 2. List the other products bought by customers who bought computers
: How to use Docker to make a project containerized, I have 5 Java Spring boot microservices and an SQL data base, each microservice connects to different port
To do so, they need a current listing of the department managers to contact. For this query, the HR department needs the department name
What SQL query would you write so that each member type is represented in each and every dues cycle?
Write SQL statement to show all parts with cost between 10 and 50. Write SQL statement to show all the repairs that were performed in March 2022.
Write a SQL statement to display category ID and category name for products that are more expensive than the most expensive product in category
Write SQL script to insert sample data to the tables. Use your name for one of the employee record. Submit also sql script.
Generate SQL query to display the product ID, product name, category name, and unit price of the highest and lowest paid product(s).
Create, modify, and drop tables based on design specifications provided. Create a table using the structure and data from an existing table.
Write select statement based on the InvoiceTotal column of the Invoices table: Use the CAST function to return the first column as an integer value.
Create a query that lists all the customer numbers from the customers table in Ascending order. Take note of how many customers have placed an order.
Write a SQL statement to display category ID and category name for products that are more expensive than the most expensive product in category 2.