办件统计sql代码

全年查询

SELECT

	sum(zs)
FROM
	(
		SELECT
			count(*) AS zs
		FROM
			dealsheetpage_wzs t
		WHERE
			t.ISWEBSITE = '1'
		AND sbdate LIKE '2020%'
		UNION ALL
			SELECT
				count(*) AS zs
			FROM
				dealsheetpage_con_wzs t
			WHERE
				sbdate LIKE '2020%'
	) AS n
UNION ALL
	SELECT
		sum(zs)
	FROM
		(
			SELECT
				SUM(t.DSHANDLE) AS zs
			FROM
				dealsheetpage_wzs t
			WHERE
				t.dsdealdate LIKE '2020%'
			UNION ALL
				SELECT
					count(*) AS zs
				FROM
					dealsheetpage_con_wzs t
				WHERE
					t.dsdealdate LIKE '2020%'
		) AS n
	UNION ALL
		SELECT
			sum(zs)
		FROM
			(
				SELECT
					SUM(t.DSHANDLE) AS zs
				FROM
					dealsheetpage_wzs t
				WHERE
					t.dsdealdate LIKE '2020%'
				AND t.factfinishdate IS NULL
				UNION ALL
					SELECT
						count(*) AS zs
					FROM
						dealsheetpage_con_wzs t
					WHERE
						t.dsdealdate LIKE '2020%'
					AND t.factfinishdate IS NULL
			) AS n
		UNION ALL
			SELECT
				sum(zs)
			FROM
				(
					SELECT
						SUM(t.DSHANDLE) AS zs
					FROM
						dealsheetpage_wzs t
					WHERE
						t.finishstate = '0'
					AND t.dsdealdate LIKE '2020%'
					UNION ALL
						SELECT
							count(*) AS zs
						FROM
							dealsheetpage_con_wzs t
						WHERE
							t.finishstate = '0'
						AND t.dsdealdate LIKE '2020%'
				) AS n
			UNION ALL
				SELECT
					sum(zs)
				FROM
					(
						SELECT
							SUM(t.DSHANDLE) AS zs
						FROM
							dealsheetpage_wzs t
						WHERE
							t.finishstate = '1'
						AND t.dsdealdate LIKE '2020%'
						UNION ALL
							SELECT
								count(*) AS zs
							FROM
								dealsheetpage_con_wzs t
							WHERE
								t.finishstate = '1'
							AND t.dsdealdate LIKE '2020%'
					) AS n