ソースコード
SELECT [S].[SALES_DATE] AS [SAL_DATE]
,[SD].[SALES_NO] AS [NO]
,[SD].[ITEM_CODE] AS [ITEM_CODE]
,[SD].[SALES_QTY] AS [SAL_QTY]
,[SD].[DELIVERED_QTY] AS [DEL_QTY]
,CASE WHEN [SD].[DELIVERED_QTY] = 0 THEN '未出荷'
      WHEN [SD].[DELIVERED_QTY] <> 0
            AND [SD].[SALES_QTY] > [SD].[DELIVERED_QTY]
            THEN '一部出荷'
      WHEN [SD].[DELIVERED_QTY] = [SD].[SALES_QTY] THEN '出荷済'
      END AS [SHIP_STS]
FROM [SALES] AS [S]
LEFT OUTER JOIN [SALES_DTL] AS [SD]
ON [S].[SALES_NO] = [SD].[SALES_NO]
ORDER BY [S].[SALES_DATE] DESC
,[SD].[SALES_NO] ASC
,[SD].[ITEM_CODE] ASC
提出情報
提出日時2024/06/10 11:45:28
コンテスト第1回 SQLコンテスト初級編
問題出荷状況確認
受験者kkkkyyyy
状態 (詳細)WA
(Wrong Answer: 誤答)
メモリ使用量88 MB
メッセージ
テストケース(通過数/総数)
0/2
状態
メモリ使用量
データパターン1
WA
88 MB
データパターン2
WA
87 MB