void query_one(Connection conn)
	{
		try
		{
			PreparedStatement ps = conn.prepareStatement(

				"create view Q6a as" +
				"SELECT tutorialRef, timeOfDay, COUNT(*) \"AM_BOOKED\" " +
				"FROM Attending pt, TutorialSession ts" +
				"WHERE (pt.tsRef = ts.tsRef) and timeOfDay = \'am\'" +
				"GROUP BY tutorialRef, timeOfDay;"
			);

			ResultSet rs = ps.executeQuery();



		} catch (Exception e) {}
	}

	void query_two(Connection conn)
	{
		try
		{
			PreparedStatement ps = conn.prepareStatement(

				"create view Q6b as" +
				"SELECT tutorialRef, timeOfDay, COUNT(*) \"PM_BOOKED\" " +
				"FROM Attending pt, TutorialSession ts" +
				"WHERE (pt.tsRef = ts.tsRef) and timeOfDay = \'pm\'" +
				"GROUP BY tutorialRef, timeOfDay"
			);

			ResultSet rs = ps.executeQuery();



		} catch (Exception e) {}
	}

	void query_three(Connection conn)
	{
		try
		{
			PreparedStatement ps = conn.prepareStatement(

				"create view Q6c as" +
				"select Q6a.tutorialRef" +
				"from Q6a, Q6b" +
				"where Q6a.tutorialRef = Q6b.tutorialRef" +
				"AND Q6b.PM_BOOKED > Q6a.AM_BOOKED"
			);

			ResultSet rs = ps.executeQuery();



		} catch (Exception e) {}
	}

	void query_four(Connection conn)
	{
		try
		{
			PreparedStatement ps = conn.prepareStatement(

				"SELECT TITLE" +
				"FROM tutorial, Q6c" +
				"WHERE tutorial.tutorialNo = Q6c.tutorialRef" +
				"ORDER BY TITLE"
			);

			ResultSet rs = ps.executeQuery();
			while(rs.next())
			{
				System.out.println(rs.getString(1));
			}


		} catch (Exception e) {}
	}

	void query_drop(Connection conn)
	{
		try
		{
			PreparedStatement ps = conn.prepareStatement(

				"drop view Q6a;" +
				"drop view Q6b;" +
				"drop view Q6c;"
			);

			ResultSet rs = ps.executeQuery();



		} catch (Exception e) {}
	}