求sql语句，怎么写？谢谢

[nitaiyoucala]

建表数据。

CREATE TABLE [dbo].[tb1](
	[编号] [int] IDENTITY(1,1) NOT NULL,
	[部门] [nvarchar](50) NULL,
	[数量] [int] NULL,
	[新增时间] [date] NULL,
	[提交时间] [date] NULL,
 CONSTRAINT [PK_tb1] PRIMARY KEY CLUSTERED 
(
	[编号] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET IDENTITY_INSERT [dbo].[tb1] ON 

GO
INSERT [dbo].[tb1] ([编号], [部门], [数量], [新增时间], [提交时间]) VALUES (1, N'F1', 1, CAST(N'2018-03-04' AS Date), CAST(N'2018-03-04' AS Date))
GO
INSERT [dbo].[tb1] ([编号], [部门], [数量], [新增时间], [提交时间]) VALUES (2, N'F1', 4, CAST(N'2018-03-04' AS Date), CAST(N'2018-03-05' AS Date))
GO
INSERT [dbo].[tb1] ([编号], [部门], [数量], [新增时间], [提交时间]) VALUES (3, N'F2', 3, CAST(N'2018-03-05' AS Date), CAST(N'2018-03-05' AS Date))
GO
SET IDENTITY_INSERT [dbo].[tb1] OFF
GO

需要下面结果

[Main_csdn_String]

你这个是作业把。

[Main_csdn_String]

/* Navicat MySQL Data Transfer Source Server : 本地 Source Server Version : 50703 Source Host : 127.0.0.1:3306 Source Database : test Target Server Type : MYSQL Target Server Version : 50703 File Encoding : 65001 Date: 2018-03-06 18:28:29 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `tbl_department` -- ---------------------------- DROP TABLE IF EXISTS `tbl_department`; CREATE TABLE `tbl_department` ( `id` int(11) NOT NULL, `section` varchar(50) DEFAULT NULL, `number` int(11) DEFAULT NULL, `newDate` datetime DEFAULT NULL, `inputDate` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tbl_department -- ---------------------------- INSERT INTO `tbl_department` VALUES ('1', 'F1', '1', '2018-03-05 18:26:42', '2018-03-05 18:26:47'); INSERT INTO `tbl_department` VALUES ('2', 'F1', '4', '2018-03-06 18:27:52', '2018-03-06 18:27:54'); INSERT INTO `tbl_department` VALUES ('3', 'F2', '3', '2018-03-06 18:28:06', '2018-03-06 18:28:10');