By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE [dbo].[orders](
[id] [int] IDENTITY(1,1) NOT NULL,
[orderDate] [date] NULL,
[productCode] [varchar](50) NULL,
[qty] [float] NULL,
[price] [float] NULL,
[deadLine] [date] NULL,
CONSTRAINT [PK_orders] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE [dbo].[sales](
[id] [int] IDENTITY(1,1) NOT NULL,
[salesDate] [date] NULL,
[productCode] [varchar](50) NULL,
[qty] [float] NULL,
[price] [float] NULL,
CONSTRAINT [PK_sales] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
SET IDENTITY_INSERT [dbo].[orders] ON
INSERT [dbo].[orders] ([id], [orderDate], [productCode], [qty], [price], [deadLine]) VALUES (1, CAST(N'2022-10-01' AS Date), N'a', 10, 15, CAST(N'2022-12-01' AS Date))
INSERT [dbo].[orders] ([id], [orderDate], [productCode], [qty], [price], [deadLine]) VALUES (2, CAST(N'2022-10-02' AS Date), N'b', 20, 25, CAST(N'2023-01-01' AS Date))
INSERT [dbo].[orders] ([id], [orderDate], [productCode], [qty], [price], [deadLine]) VALUES (3, CAST(N'2022-10-03' AS Date), N'c', 30, 35, CAST(N'2023-02-02' AS Date))
INSERT [dbo].[orders] ([id], [orderDate], [productCode], [qty], [price], [deadLine]) VALUES (4, CAST(N'2022-10-04' AS Date), N'd', 40, 45, CAST(N'2023-03-03' AS Date))
SET IDENTITY_INSERT [dbo].[orders] OFF
SET IDENTITY_INSERT [dbo].[sales] ON
INSERT [dbo].[sales] ([id], [salesDate], [productCode], [qty], [price]) VALUES (1, CAST(N'2022-11-01' AS Date), N'a', 3, 14)
INSERT [dbo].[sales] ([id], [salesDate], [productCode], [qty], [price]) VALUES (2, CAST(N'2022-11-02' AS Date), N'b', 4, 25)
13 rows affected
select * from orders
select * from sales
| id | orderDate | productCode | qty | price | deadLine |
|---|---|---|---|---|---|
| 1 | 2022-10-01 | a | 10 | 15 | 2022-12-01 |
| 2 | 2022-10-02 | b | 20 | 25 | 2023-01-01 |
| 3 | 2022-10-03 | c | 30 | 35 | 2023-02-02 |
| 4 | 2022-10-04 | d | 40 | 45 | 2023-03-03 |
| id | salesDate | productCode | qty | price |
|---|---|---|---|---|
| 1 | 2022-11-01 | a | 3 | 14 |
| 2 | 2022-11-02 | b | 4 | 25 |
| 3 | 2022-11-03 | a | 1 | 16 |
| 4 | 2022-11-04 | b | 3 | 20 |
| 5 | 2022-11-05 | b | 8 | 24 |
| 6 | 2022-11-06 | a | 5 | 24 |
| 7 | 2022-11-07 | b | 41 | 20 |
| 8 | 2022-11-08 | d | 10 | 35 |
| 9 | 2022-11-09 | a | 4 | 10 |