Interview Test Banner Tracking Report

Please put your work on these placeholder pages and use code-behind class files so we can see your code (please don't compile into DLL files):
« Back To Home

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

Please create query that returns:
Banner Name and Banner Link columns and sum of all all impressions and sum of all clicks between 11/18/2023 and 11/24/2023

Results located at the bottom of the page.

Please bind the result to the gridview and display this gridview below

Banner table

BannerTracking table

Banner table data

BannerTracking table data


Output from DB

NameLinkTotalImpressionsTotalClicks
Free Shipping - Lefthttp://localhost26137
Gift Certificatehttp://localhost26135
Logo - Lefthttp://localhost63837
Phone number - Lefthttp://localhost63832
Privacy - Largehttp://localhost26138
Privacy -Smallhttp://localhost37724
Satisfaction - Largehttp://localhost26136
Satisfaction -Smallhttp://localhost37725
Verisign Seal - Largehttp://localhost26140
Verisign Seal -Smallhttp://localhost37736