DRAG DROP
You administer a SQL Server database that tracks sales that are made by sales persons. The database contains a table that is defined by the following Transact-SQL statements:
You have the following requirements: accept a datetime value for the query month
return a list of salespeople IDs who have sales in the query month or before the query month compare sales with sales quota for salespeople who have a sales quota display year-to-date sales for salespeople that do not have a sales quota
How should you complete the stored procedure? To answer, drag the appropriate Transact-SQL segments to the correct locations. Each Transact-SQL segment may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Select and Place:
