Level 20

SQL practice

Write a query that returns exactly what the task asks for. Only SELECT works here, the data cannot be changed. If your result matches, you will see a green message.

Task 1

Find the average price of droids and astromechs made by the maker Cybot, taken together. Output: one overall average price.

Your query

Ctrl + Enter

Database schema

Fleet

classesclass, type, faction, turbolasers, bore, displacement
shipsname, class, launched
battlesname, year
outcomesship, battle, result

A class is named after its lead ship, or after the design; then no ship carries that name. classes: type is sd (Star Destroyer) or cr (cruiser); turbolasers is the number of main guns, bore their caliber, displacement the mass in kilotons. ships: launched is the year relative to the Battle of Yavin. battles: year in the same scale. outcomes: result is sunk, damaged or OK. Note: outcomes may include ships that are not in ships (then the ship is the lead ship of the class of the same name), and a sunk ship never takes part in a later battle.

Droid Factory

productmaker, model, type
droidcode, model, speed, ram, hd, holo, price
astromechcode, model, speed, ram, hd, price, screen
blastercode, model, color, type, price

product lists the maker, model and type (Droid, Astromech or Blaster) of everything the factory sells; model numbers are unique. droid: speed is the processor in MHz, ram in MB, hd is memory in GB, holo is the holoprojector speed (the number before "x"); one model can have several rows. astromech is like droid, but has a screen size in inches instead of a holoprojector. blaster: color is y for a colored bolt, n otherwise; type is Laser, Ion or Scatter.