Beyond, Inc. Interview Question

There really wasn't any difficult question. Just make sure you know how to answer the same problem in multiple ways (sql)