Create a query in Query Design view based on both tables to answer the question, What is the Sponsor Name, Concert Name, and Concert Location for a sponsor name that has radio anywhere in its name and for a concert name that ends in festival sorted in ascending order by the Concert Location field

Jason typically uses the internet to buy various items. it the total cost of all of the items ordered, at one time, is $250 or more, then the shipping and handling is free, otherwise the shipping and handling is $15 per item. design an algorithm that prompts jason to enter the number of items ordered and the price of each item. (remember cost = number of items order times price) the algorithm then outputs the total billing amount including shipping and handling. your algorithm must use a loop (repetition structure) to get the number and price of each item. write this in algorithm format not program code format.