Canvas留学生辅导、Python/Java编程讲解、辅导c/c++、column讲解讲解Database|解析R语言编程

Question 1 7.5 pts
*** QUESTION 1 (ONE) ***
Enter into Canvas the number of products which are Blue or Black in colour, according to the "Color" column.

Flag this Question
Question 2 7.5 pts
*** QUESTION 2 (TWO) ***
Find how many products weigh more than 3.5 kilograms and have a list price of at least $1700.99. Assume product weights are given in grams.

Enter into Canvas the number of products found above.

Flag this Question
Question 3 7.5 pts
*** QUESTION 3 (THREE) ***
Using a product's name only, find how many products are Blue or Yellow in colour.

Enter into Canvas the number of products found above.

Flag this Question
Question 4 7.5 pts
*** QUESTION 4 (FOUR) ***
Find how many products satisfy the following criteria:
-Does not have a single colour (i.e. has multiple colours or no (known) colour)
-Has a weight
-Has no size

Enter into Canvas the number of products found above.

Flag this Question
Question 5 7.5 pts
*** QUESTION 5 (FIVE) ***
Enter into Canvas the number of products listed for sale in 2005 which have not yet been discontinued nor have they been ended.

Question 17.5?pts
*** QUESTION 6 (SIX) ***
Enter into Canvas the number of customer addresses in the USA that are registered as billing or shipping addresses.
Flag this Question
Question 27.5 pts
*** QUESTION 7 (SEVEN) ***
Write a query to return the following result set:
Columns:
- CompanyName
- SalesOrderNumber
- SalesOrderDetailID
- Product Name
- ProductModel Name

Rows:
- Order details for products which are Tires (according to their model name), with the order number and customer's company name.

Sort:
- SalesOrderDetailID ascending

There should be 20 rows.

Enter into Canvas the SalesOrderNumber in row 13 from the query's result.

Flag this Question
Question 37.5?pts
*** QUESTION 8 (EIGHT) ***
Write a query to return the following result set:
Columns:
- SalesOrderDetailID
- OrderQty
- UnitPrice
- LineTotal
- Name (from Product)
- Description (from ProductDescription)

Rows:
- Sale order details with their products and products' descriptions
- Ordered products without discounts only
- English product descriptions only

Sort:
- Order the result set by SalesOrderDetailID ascending

From the result, find the description in row 436 and enter into Canvas its rowguid value.

Flag this Question
Question 47.5?pts
*** QUESTION 9 (NINE) ***
Find all addresses in the UK which are not assigned to a customer. Order your result ascendingly by AddressID.

You are encouraged to use an outer join in your query to answer this question.

Enter into Canvas the name of the city of the address in row 11.

Flag this Question
Question 57.5?pts
*** QUESTION 10 (TEN) ***
Find all customers who have ever ordered products categorised as any of the following four categories:
1. Bike Stands
2. Cleaners
3. Fenders
4. Touring Bikes

Enter into Canvas the number of unique (different) customers found in the list above.

Canvas留学生辅导、Python/Java编程讲解、辅导c/c++、column讲解 讲解Database|解析R语言编程

Canvas留学生辅导、Python/Java编程讲解、辅导c/c++、column讲解讲解Database|解析R语言编程