Question: How do I add a new field to the query? Please help with this problem! Create a query from the Winery and Wine tables. Display

How do I add a new field to the query? PleaseHow do I add a new field to the query? PleaseHow do I add a new field to the query? Please help with this problem!

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!