CertiAce

Design and develop database solutions

You are writing a sales report in Azure SQL Database from a table named DailyStoreSales. The report must show a revenue rank within each store where tied revenue values share the same rank and ranks remain consecutive, and it must show a row-by-row running revenue total within each store ordered by BusinessDate and SalesBatchId. Which two select-list expressions should you include? (Select all that apply)

Select all correct answers:

CertiAceAboutTerms of ServicePrivacy PolicySign up