SELECT BRAND_NAME, BRAND_TYPE, round(AVERAGE,2) AS 'Average Price', UnitsSold FROM (LGBRAND INNER JOIN (SELECT BRAND_ID, AVG(PROD_PRICE) AS AVERAGE FROM LGPRODUCT GROUP BY BRAND_ID) AS SUB1 ON LGBRAND.BRAND_ID = SUB1.BRAND_ID) INNER JOIN (SELECT BRAND_ID, SUM(LINE_QTY) AS UNITSSOLD FROM LGPRODUCT INNER JOIN LGLINE ON LGPRODUCT.PROD_SKU = LGLINE.PROD_SKU GROUP BY BRAND_ID) AS SUB2 ON LGBRAND.BRAND_ID = SUB2.BRAND_ID ORDER BY BRAND_NAME

Q: Difference between count (*) and count (col_name). Explain with an example.

A: The above question is solved in step 2 :-

Q: How do scalar functions and table-valued functions differ in SQL, and when might each be preferred?

A: User-defined functions are adaptable tools for encapsulating logic and boosting query capabilities…

Q: Build two SQL queries that combine film and category information. List the film’s title, film’s…

A: Creating Film table: CREATE table FILM (    filmID   NUMBER(3) NOT NULL,    filmTitle  VARCHAR2(50)…

Q: How does the COALESCE function compare with the ISNULL function when handling NULL values in SQL

A: The COALESCE and ISNULL functions are both used to handle NULL values in SQL. However, they have…

Q: Write a SELECT statement that returns two columns based on the Vendors table. The first column,…

A:

Q: EmployeelD Last Name First Name Address City Province PostalCode Phone BirthDate 507 - 20th Ave.…

A: 1- A trigger is created for AFTER insert situation. 2- When a row is inserted, a copy of the row is…

Q: How do I create a query that includes first name, last name, email and state for all customers and…

A: Query:-   SELECT first_name, last_name, email, state, CASE WHEN customer_type = 'Customer' THEN 'C'…

Q: What are the advantages of using table-valued parameters in SQL functions

A: Table-valued parameters (TVPs) in SQL are a powerful feature that allows developers to send multiple…

Q: For each department with more than one member of employee, find the sum of reward amounts for each…

A: The question is solved in step2

Q: Using the retail.inventory table, pull the current stock percentage out of the future stock level…

A: The following solution is

Q: Write an SQL Query that will show the following attributes from theORDERS table: ORDER #, CUSTOMER…

A: “ORDER BY” Clause: SQL contains "ORDER BY” clause in order to sort rows. The values get sorted in…

Q: Perform a LEFT OUTER JOIN between the tables Wicketkeeping and Batting. You may select any…

A: SELECT * FROM Batting b LEFT OUTER JOIN WicketKeeping w ON b.Player = w.Player;

Q: Using the EMP_2 table, write the SQL code that will add the attributes EMP_PCT and PROJ_NUM to…

A: The question is asking for an SQL command that will add two new columns to an existing table named…

Q: Write a SQL query. List names of all employees who have sold to customer Rachel Patterson (Note: You…

A: In this database problem, we are tasked with creating an SQL query that lists the names of all…

Q: What is the primary key for the APARTMENTS table? (It may be a composite key involving 2 or more…

A: The question asks to identify the primary keys and foreign keys for the "APARTMENTS" and "RENTERS"…

Q: With SQL code, find the name of each employee with a manager along with their manager's name (use…

A: For finding this query  we will use the join clause.

Q: So here I have 2 tables and I need help understanding the basics of joins. I have developed some…

A: I have given solution below.