Create A Query From The Winery And Wine Tables Display The Winery Id Winery Name Wine Id Description Retail Value A 1 (38.76 KiB) Viewed 66 times
Create a query from the Winery and Wine tables. Display the Winery Id, Winery name, Wine Id, description, retail value and EntryDate_Competition. Sort in ascending order by EntryDate_Competition. Add a new field to the query, name the field: Days Since Entry. This field is calculated by subtracting the EntryDate_Competition (Winery Table) from February 20, 2022. Only display the records that entered the Wine Competition longer than 30 days from February 20, 2022. Name query: Winery and Entry Date over 30 days - Query 1 -
Category Table Classification Table Wine Table Winery Id Query1 X Winery Id Wine Table 8 Winery Id WineryName Address City State Zip Code Phone Number EmailAddress Contact BondedNumber EntryDate Competition * Wine ID Description Vintage Appellation Sugar % Alcohol % Retail Value Vineyard Quantity on Hand Class Winery Id 100 WineryName Winery Id Wine ID Wine Table Description Wine Table Retail Value Wine Table Field: Winery Id Table: Winery Id Sort: Show: Criteria: or: EntryDate Competitic Winery Id Ascending SI O Num Lock SQL
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!