You have a quarterly sales data set that contains a date field, with each business day written as a value for orders placed on that day. You need to find the days on which sales did not occur, and you do not have every day of the time period in your data. What should you introduce into your model?Select an answer:Add a date table joined to the data set. The join should provide all dates in the time period and the associated records.Create calculations that look for dates that don't exist, and then provide the next date needed.Inform the leadership that this report is not possible.Open the data set and add records that represent the dates that are not present in the data set.

You have a Microsoft SQL Server database that contains tables named Customers and Orders. The tables are related by a column named CustomerID. You need to create a query that meets the following requirements:1. Returns the CustomerName for all customers and the OrderDate for any orders that they have placed. 2. Results must include customers who have not placed any orders. Which Transact-SQL query should you use? SELECT CustomerName, OrderDate FROM Customers RIGHT OUTER JOIN Orders ON Customers.CustomerID = Orders.CustomerID SELECT CustomerName, CrderDate FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID SELECT CustomerName, OrderDate FROM Customers CROSS JOIN Orders ON Customers.CustomerID = Orders.CustomerID SELECT CustomerName, OrderDate FROM Customers LEFT OUTER JOIN Orders ON Customers.CustomerID = Orders.CustomerID

We need to create a report to display the order id, ship date and order total of your ORDER table. If the order has not been shipped, your report must display 'Not Shipped'. If the total is not available, your report must display 'Not Available'.In the ORDER table, the SHIPDATE column has a datatype of DATE. The TOTAL column has a datatype of INT.Which statement do you use to create this report?Select one:a.SELECT ordid,TO_CHAR(shipdate, 'Not Shipped'),TO_CHAR(total,'Not Available')FROM order;b.SELECT ordid, IFNULL(shipdate, 'Not Shipped') as SHIPDATE,Total FROM order;c.SELECT ordid, NVL(to_char(shipdate), 'Not Shipped') SHIPDATE,NVL(total,'Not Available')TOTAL FROM order;d.SELECT ordid, shipdate "Not Shipped",total "Not Available"FROM order;

Sophie is working on sales data from her company and wishes to only see sales from March while hiding the sales from all other months of the year. What steps should she take?1 pointConvert her data into a table and filter the month column to only show the sales from March.Convert her data into a table and sort the table by month. Then, delete the sales data from all other months of the year.Highlight the data from March and copy it into a new worksheet to create a new table with the March sales data.

You have a Microsoft SQL Server database that contains tables named Customers and Orders. The tables are related by a column named CustomerID. You need to create a query that meets the following requirements:1. Returns the CustomerName for all customers and the OrderDate for any orders that they have placed. 2. Results must include customers who have not placed any orders. Which Transact-SQL query should you use?

You are tasked with maintaining a record of daily purchases made by customers. To accomplish this, you need to create a view named daily_purchase_summary. This view will provide a summary of the daily purchases, including the total number of orders placed and the total purchase amount for each day. The purchase amount should be rounded to two decimal places for accuracy.