Interview Test Banner Tracking Report

< Back

There are 2 tables in the database "webapp" called: Banner and BannerTracking.

Please create a query that returns:

Banner Name and Banner Link fields and the sum of all impressions and the sum of all clicks between 11/18/2021 and 11/24/2021

Please bind the result to a WebGrid and display this WebGrid below. The WebGrid NuGet package has already been added for your convenience.

Banner table

Banner Table Design

BannerTracking table

BannerTracking Table Design

Banner table data

Banner Table Data

BannerTracking table data

BannerTracking Table Data