SQL Assessment A database contains the following three tables with information about New York City East River Bicycle crossings and weather Weather Bridge 4/1/2016 BrooklynBridge 4/1/2016 ManhattanBridge 4/1/2016 QueensboroBridge 4/1/2016 WilliamsburgBridge 4/2/2016 BrooklynBridge Date 1704 4/1/2016 3126 4/2/2016 2552 4/3/2016 41154/4/2016 827 4/5/2016 Date Crossings HighTemp F LowTemp F Precipitation 78.1 39.9 44.1 42.1 48.9 34 33.1 26.1 0.01 0.15 0.09 0.47 Calendar DateYear Month Day DayofWeek WeekofYear 14 14 15 15 15 /1/2016 2016 4 1 Friday 4/2/2016 2016 4/3/2016 2016 4/4/2016 2016 4/5/2016 2016 42 Saturday 43 Sunday 4 Monday 45 Tuesday 1. In the space below, write a query to display all data from the BicycleBridgeCrossings table 2. In the space below, write a query to display the total number of BicycleBridgeCrossings by day 3. In the space below, write a query joining the Calendar table to the BicycleBridgeCrossings table and displaying average number of Bicycle crossings by Day Of Week for the Brooklyn Bridge 4. In the space below, write a query joining the Weather and Calendar table to the BicycleBridgeCrossings table and displaying all results