migrate queries from mrosier_test in bigquery console

[MarquiseRosier]

@langswei is asking to have queries moved from something that ends in test; and into something with better naming.