An engineer looks at two elements in the same group of the periodic table. What similarity should the engineer expect based on their positions?

A material is tested for strength in several directions. Its strength changes depending on the direction of testing. Which term best describes this behavior?

How many customers are in each region? SELECT    region,    COUNT(*) AS num_customersFROM customersGROUP BY regionORDER BY region; Enter the count by region.   [a]  Midwest [b]  Northeast [c]  South [d]  West

What was the average nightly rate by season? SELECT     CASE         WHEN MONTH(checkin_date) IN (12,1,2) THEN ‘Winter’        WHEN MONTH(checkin_date) IN (6,7,8) THEN ‘Summer’        ELSE ‘Other’    END AS season,    ROUND(AVG(price_per_night), 2) AS avg_priceFROM bookingsGROUP BY seasonORDER BY season DESC; Enter the values for each season.   [a]  Winter [b]  Summer [c]  Other

What is the average number of available rooms in each hotel? SELECT ROUND(AVG(rooms_available), 1) AS avg_available_roomsFROM hotels; Enter the value.

How many hotel bookings were there by month? SELECT     MONTH(checkin_date) AS month_number,    COUNT(*) AS total_bookingsFROM bookingsGROUP BY MONTH(checkin_date)ORDER BY month_number; Upload a well-formatted line chart.

How many hotels do we have? SELECT COUNT(*) AS num_hotelsFROM hotels; Enter the count.

What was the average unit cost for each ingredient? For example, what was the average cost for each pound of bell peppers? Sort the results by ingredient in alphabetical order. Round to two decimal places. Enter the unit cost for the ingredients below.   [a]  avocado [b]  basil

Write Queries

Categorize and count ingredients based on their unit cost. Use CASE WHEN to accomplish this. Ingredients should be categorized into these groups: low cost — less than or equal to $1 medium cost — less than or equal to $2, but greater than $1 high cost — greater than $2 (Round to two decimal places.) Enter the counts for each category.   [a]  low cost [b]  medium cost [c]  high cost