show a sql query to find total number of completed tests from dogs table.

 present a sql query to find number of cities that subscribed from 'WA' state.

 present a sql query to find the average of dogs' weights that born after 2011.

 present a sql query to report subcategory names where subcategory name and test name are similar otherwise report 'not match';

 report subcategorys which completed test records are updated after 2013-07-30?