List the item ID as ITEM_ID and description as ITEM_DESC for all items. The descriptions should appear in uppercase letters.

Q: -- 1 - Write a view to show all data from Sales.SalesPerson table

A: Introduction: A view in SQL is a hypothetical table constructed from a SQL statement's result set.…

Q: The query should list all employees whose Position begins with the word greenhouse and whose weekly…

A: These question answer is as follows,

Q: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: Form to complete before calling Medlink

A: MedLink which refers to the one it is a suite of mobile apps that provide access to health and…

Q: Table Name: CUSTOMERS FIELD NAME DATA TYPE CONSTRAINT DESCRIPTION (do not include this in the CREATE…

A: SQL Command to add validation in CTYPE attribute of the table CUSTOMERS is: Alter Table Customers…

Q: Differentiate between the WHERE, OUTPUT and the ORDER BY clause.

A: We are going to understand the differences between the WHERE, OUTPUT and the ORDER BY clause. I will…

Q: 1. Write an SQL query to find the CUSTOMERNAME who order the COMPUTERS. 2. Write an SQL query to…

A: It is defined as a Structured Query Language, is a programming language designed to manage data…

Q: 1. Apply a data validation for the ID Code Column that will only accept entry of 2 letters followed…

A: Goto data tab, select data validation and then select Data Validation. In the new window, In the…

Q: QUESTION 15 use the follwoing  picture to answer the question Write a select statement which should…

A: Select INVENTORY.ITEM_SIZE, INVENTORY.COLOR, INVENTORY.CURR_PRICE,ORDER.ORDER_IDInner join on

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: Write a SELECT statement that uses a correlated subquery to return one row per customer,…

A: SYNTAX - SELECT cust.first_name, cust.last_name, o.order_id, o.order_date, o.total_quantityFROM…

Q: The tblCities table contains a numeric field named Population. Which of the following LINQ…

A: The LINQ statement that selects all cities having a population that exceeds 15000 is below, Dim…

Q: What is the default order by command value?

A: NOTE  :-  Below i explain the answer in my own words by which you understand it well.   ASC is the…

Q: Name the Hourly Rate and Hours Worked arrays. Calculate the total cost of labour using SumProduct.…

A: SUMPRODUCT - This function in excel is used to multiply numerical type arrays together and returns…

Q: Retrieve the employee_id, First_name, Last Name as Full Name, and net salary (salary + commission)…

A: required: To Retrieve the employee_id, First_name, Last Name as Full Name, and net salary (salary +…

Q: _FNAME VARCHAR(15) NOT NULL, INITIAL CHAR(1), _AREACODE CHAR(3) DEFAULT '615' NOT N…

A: Given CREATE 'TABLE CUSTOMER CU S_CODE NUMBER PRIMARY KEY, CUS_LNAME VARCHAR( 1 5) NOT NULL,…

Q: 8. Use a SELECT statement to view the CURRVAL of NUMGEN. Delete the NUMGEN synonym and MY_FIRST_SEQ.

A: Please check the solution below

Q: price = 4 num = 5 Select the most appropriate replacement field definitions. total = num * price…

A: The format() method formats the supplied value or values and inserts them into the string…

Q: Add to the LARGE_PROPERTY table a new character column named OCCUPIED that is one character in…

A: Since the question did not specify the which DBMS tool (Oracle or SQL Server or MySQL has to be…

Q: Please read the instrucitons before posting an answer that someone else has already posted.…

A: The new query is given below without using GROUP_CONCAT

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

Q: Please complete the code to display the result on the counsel. from decimal import Decimal, Blank 1…

A: The complete Python code is given below along with output screenshots

Q: Display the final price in the following format:  The final price is $_____. Please include the…

A: i have used the go code for the following requirement

Q: What is the default order by command value?

A: What is the default order by command value?

Q: Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To…

A: Sure, I can help you with that. The StayWell marketing team wants to send small gifts to all…

Q: te this form please. Random

A: I have written the HTML Code below:

Q: you are supposed to create an excel sheet for student grade sheet. There must be at least 10…

A: COUNTIF(range,criteria) : is used to count any occurrence of data. IF function return true or false…

Q: Use a LIST to store the sales data for each month with the three-letter abbreviation for the month…

A: Below i have given SQL queries:

Q: 10. Produce a list of each customer number and the third and fourth digits of his or her zip code.…

A: The query for a list of each customer number and the third and fourth digits of his or her zipcode…

Q: Field Туре Null Key Default Extra ITEM_ID char(4) NO PRI NULL DESCRIPTION char(30) YES NULL ON HAND…

A: SQL is structured query language used to create and maintain data in a database. SQL has direct…

Q: Complete the Where clause in the following statement, which should select only records whose…

A: The where clause for LastName field beginning with upper case is written as follows.     Where…

Q: When is it appropriate to nest a subquery within a HAVING clause?

A: answer is

Q: Write a SELECT statement that uses the ranking functions to rank products by the total quantity…

A: This query uses a JOIN between the Products and Order_Items tables to get the total quantity of each…

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.