jgc128

SELECT 
[Project2].[id] AS [id], 
[Project2].[stimul] AS [stimul]
FROM ( SELECT 
	[Extent1].[id] AS [id], 
	[Extent1].[stimul] AS [stimul]
	FROM [dbo].[stimuls] AS [Extent1]
	WHERE  EXISTS (SELECT 
		1 AS [C1]
		FROM [dbo].[reactions] AS [Extent2]

jgc128

CREATE TABLE dae.dbo.stimuls(
  id INT IDENTITY,
  stimul NVARCHAR(100) NOT NULL,
  CONSTRAINT PK_stimuls PRIMARY KEY (id)
)
GO

jgc128

{SELECT 
[Project6].[id] AS [id], 
[Project6].[C1] AS [C1], 
[Project6].[stimul] AS [stimul], 
[Project6].[C3] AS [C2], 
[Project6].[C2] AS [C3], 
[Project6].[reaction] AS [reaction], 
[Project6].[C4] AS [C4]
FROM ( SELECT 
  [Project1].[id] AS [id], 

jgc128

SELECT customer_name, cust_date
FROM customer
JOIN cust ON customer.customer = cust.customer_id
WHERE EXTRACT(MONTH FROM cust_date) = EXTRACT(MONTH FROM DATEADD(-1 MONTH TO CURRENT_DATE))