 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
--- Dump completed on 2015-04-01 12:50:04
+-- Dump completed on 2015-04-08 17:23:15

UNLOCK TABLES;

--
-- Table structure for table `pitching`
--


INSERT INTO `team` VALUES ('WAS','Nationals','Washington Nationals','Nationals Park','1500 South Capitol Street, SE Washington, DC 20003-1507','National League','East');
/*!40000 ALTER TABLE `team` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Final view structure for view `doherty_case1`
--

/*!50001 DROP VIEW IF EXISTS `doherty_case1`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `doherty_case1` AS select `a`.`full_name` AS `full_name`,`a`.`user_id` AS `user_id`,`a`.`followers` AS `followers` from (`account` `a` left join `player` `p` on((`p`.`player_user_id` = `a`.`user_id`))) order by `a`.`followers` desc limit 15 */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `doherty_case10`
--

/*!50001 DROP VIEW IF EXISTS `doherty_case10`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `doherty_case10` AS select `p`.`full_name` AS `full_name`,`p`.`player_user_id` AS `player_user_id` from (`player` `p` join `tweet` `t`) where (`t`.`user_id` = `p`.`player_user_id`) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `doherty_case2`
--

/*!50001 DROP VIEW IF EXISTS `doherty_case2`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `doherty_case2` AS select `p`.`full_name` AS `full_name`,`p`.`player_user_id` AS `player_user_id`,`b`.`H` AS `H` from ((`player` `p` join `batting` `b` on(((`b`.`full_name` = `p`.`full_name`) and (`b`.`dob` = `p`.`dob`)))) left join `account` `a` on((`a`.`user_id` = `p`.`player_user_id`))) where ((`b`.`H` > 0) and (`p`.`player_user_id` <> 'NULL')) order by `b`.`H` desc */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `doherty_case3`
--

/*!50001 DROP VIEW IF EXISTS `doherty_case3`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `doherty_case3` AS select `p`.`full_name` AS `full_name`,`b`.`G` AS `G` from (`player` `p` join `batting` `b` on(((`p`.`full_name` = `b`.`full_name`) and (`p`.`dob` = `b`.`dob`)))) where (`p`.`team_abbrev` = 'NYM') order by `b`.`G` desc */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `doherty_case4`
--

/*!50001 DROP VIEW IF EXISTS `doherty_case4`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `doherty_case4` AS select `pi`.`full_name` AS `full_name`,`pi`.`ERA` AS `ERA`,`pl`.`team_abbrev` AS `team` from (`pitching` `pi` join `player` `pl` on(((`pi`.`full_name` = `pl`.`full_name`) and (`pi`.`dob` = `pl`.`dob`)))) where (`pi`.`GS` > 10) order by `pi`.`ERA` limit 20 */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `doherty_case5`
--

/*!50001 DROP VIEW IF EXISTS `doherty_case5`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `doherty_case5` AS select `p`.`full_name` AS `full_name`,`p`.`player_user_id` AS `player_user_id`,`b`.`HR` AS `HR`,`b`.`RBI` AS `RBI` from (`batting` `b` join `player` `p` on(((`p`.`full_name` = `b`.`full_name`) and (`b`.`dob` = `p`.`dob`)))) where ((`b`.`RBI` > 0) and (`p`.`player_user_id` <> 'NULL')) order by `b`.`RBI` desc */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `doherty_case6`
--

/*!50001 DROP VIEW IF EXISTS `doherty_case6`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `doherty_case6` AS select `p`.`full_name` AS `full_name`,max(`p`.`dob`) AS `MAX(dob)` from `player` `p` where (`p`.`team_abbrev` = 'LAD') */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `doherty_case7`
--

/*!50001 DROP VIEW IF EXISTS `doherty_case7`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `doherty_case7` AS select `p`.`full_name` AS `full_name`,`p`.`player_user_id` AS `player_user_id`,`p`.`team_abbrev` AS `team_abbrev` from (`player` `p` join `account` `a` on((`p`.`player_user_id` = `a`.`user_id`))) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `doherty_case8`
--

/*!50001 DROP VIEW IF EXISTS `doherty_case8`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `doherty_case8` AS select `t`.`team_name` AS `team_name` from `team` `t` where (`t`.`team_name` = 'NYY') */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `doherty_case9`
--

/*!50001 DROP VIEW IF EXISTS `doherty_case9`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = utf8 */;
/*!50001 SET character_set_results     = utf8 */;
/*!50001 SET collation_connection      = utf8_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `doherty_case9` AS select min(`account`.`join_date`) AS `MIN(Account.join_date)` from `account` where (select `account`.`join_date` from (`account` `a` join `player` `p` on((`p`.`player_user_id` = `a`.`user_id`)))) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
