The alkali metals have a charge of ____.

The name for FeSO4 is ___.  The sulfate ion, SO4, has a -2 charge on it and iron can have a charge of +2 or +3.

For product_type, report the average sales_amount and the number of sales behind it. In a sentence, explain why the average alone could mislead someone — point to a type where the count is small.

Temperature is a measure of ____.

The compound formed between sulfur and iron is expected to be ionic or molecular?

A common table expression (CTE) is introduced with which keyword?

A consistent and logical process used in developing explanations for various phenomena is referred to as ____.

Which of the following groups has a charge of +2?

Milikan’s Oil drop experiment showed that ___.

Find the dealerships that beat their 2018 units target. For each, show the actual units sold in 2018, the units_target, and the variance (actual minus target), highest variance first.Hint: build 2018 actual units per dealership in a CTE (a COUNT of sales, dealership_id cast to int), join it to dealership_targets on dealership_id and target_year = 2018, then keep only the dealerships whose actual units exceed the target. This is the toughest problem here — chain it in named steps and test each one on its own before assembling.