Canvas留学生作业代写、Python/Java编程作业代做、

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 QuestionQuestion 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 QuestionQuestion 3 7.5 pts*** QUESTION 3 (THREE) ***Using a products name only, find how many products are Blue or Yellow in colour.Enter into Canvas the number of products found above.Flag this QuestionQuestion 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 sizeEnter into Canvas the number of products found above. Flag this QuestionQuestion 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 QuestionQuestion 27.5 pts*** QUESTION 7 (SEVEN) ***Write a query to return the following result set:Columns:- CompanyName- SalesOrderNumber- SalesOrderDetailID- Product Name- ProductModel NameRows:- Order details for products which are Tires (according to their model name), with the order number and customers company name.Sort:- SalesOrderDetailID ascendingThere should be 20 rows.Enter into Canvas the SalesOrderNumber in row 13 from the querys result.Flag this QuestionQuestion 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 onlySort:- Order the result set by SalesOrderDetailID ascendingFrom the result, find the description in row 436 and enter into Canvas its rowguid value.Flag this QuestionQuestion 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 QuestionQuestion 57.5?pts*** QUESTION 10 (TEN) ***Find all customers who have ever ordered products categorised as any of the following four categories:1. Bike Stands2. Cleaners3. Fenders4. Touring BikesEnter into Canvas the number of unique (different) customers found in the list above.本团队核心人员组成主要包括BAT一线工程师，精通德英语！我们主要业务范围是代做编程大作业、课程设计等等。我们的方向领域：window编程 数值算法 AI人工智能 金融统计 计量分析 大数据 网络编程 WEB编程 通讯编程 游戏编程多媒体linux 外挂编程 程序API图像处理 嵌入式/单片机 数据库编程 控制台 进程与线程 网络安全 汇编语言 硬件编程 软件设计 工程标准规等。其中代写编程、代写程序、代写留学生程序作业语言或工具包括但不限于以下范围:C/C++/C#代写Java代写IT代写Python代写辅导编程作业Matlab代写Haskell代写Processing代写Linux环境搭建Rust代写Data Structure Assginment 数据结构代写MIPS代写Machine Learning 作业 代写Oracle/SQL/PostgreSQL/Pig 数据库代写/代做/辅导Web开发、网站开发、网站作业ASP.NET网站开发Finance Insurace Statistics统计、回归、迭代Prolog代写Computer Computational method代做因为专业，所以值得信赖。如有需要，请加QQ：99515681 或邮箱：99515681@qq.com 微信：codehelp QQ：99515681 或邮箱：99515681@qq.com 微信：codehelp