SELECT Date_Claim_Made ,  Date_Claim_Settled FROM Claims WHERE Amount_Claimed  >  ( SELECT avg(Amount_Claimed) FROM Claims )
Among all the claims, which claims have a claimed amount larger than the average? List the date the claim was made and the date it was settled.
CREATE TABLE Customers (
Customer_ID INTEGER NOT NULL,
Customer_Details VARCHAR(255) NOT NULL,
PRIMARY KEY (Customer_ID)
);
CREATE TABLE Customer_Policies (
Policy_ID INTEGER NOT NULL,
Customer_ID INTEGER NOT NULL,
Policy_Type_Code CHAR(15) NOT NULL,
Start_Date DATE,
End_Date DATE,
PRIMARY KEY (Policy_ID),
FOREIGN KEY (Customer_ID) REFERENCES Customers (Customer_ID)
);
CREATE TABLE Claims (
Claim_ID INTEGER NOT NULL,
Policy_ID INTEGER NOT NULL,
Date_Claim_Made DATE,
Date_Claim_Settled DATE,
Amount_Claimed INTEGER,
Amount_Settled INTEGER,
PRIMARY KEY (Claim_ID),
FOREIGN KEY (Policy_ID) REFERENCES Customer_Policies (Policy_ID)
);
CREATE TABLE Settlements (
Settlement_ID INTEGER NOT NULL,
Claim_ID INTEGER NOT NULL,
Date_Claim_Made DATE,
Date_Claim_Settled DATE,
Amount_Claimed INTEGER,
Amount_Settled INTEGER,
Customer_Policy_ID INTEGER NOT NULL,
PRIMARY KEY (Settlement_ID),
FOREIGN KEY (Claim_ID) REFERENCES Claims (Claim_ID)
);
CREATE TABLE Payments (
Payment_ID INTEGER NOT NULL,
Settlement_ID INTEGER NOT NULL,
Payment_Method_Code VARCHAR(255),
Date_Payment_Made DATE,
Amount_Payment INTEGER,
PRIMARY KEY (Payment_ID),
FOREIGN KEY (Settlement_ID) REFERENCES Settlements (Settlement_ID)
);
INSERT INTO `Customers` (`Customer_ID`, `Customer_Details`) VALUES (1, 'America Jaskolski');
INSERT INTO `Customer_Policies` (`Policy_ID`, `Customer_ID`, `Policy_Type_Code`, `Start_Date`, `End_Date`) VALUES (119, 1, 'Car', '2018-01-21', '2017-12-15');
INSERT INTO `Claims` (`Claim_ID`, `Policy_ID`, `Date_Claim_Made`, `Date_Claim_Settled`, `Amount_Claimed`, `Amount_Settled`) VALUES (143, 744, '2017-03-11', '2017-11-03', 43884, 1085);
INSERT INTO `Settlements` (`Settlement_ID`, `Claim_ID`, `Date_Claim_Made`, `Date_Claim_Settled`, `Amount_Claimed`, `Amount_Settled`, `Customer_Policy_ID`) VALUES (357, 486, '2018-08-07', '2018-01-16', 38543, 1181, 515);
INSERT INTO `Payments` (`Payment_ID`, `Settlement_ID`, `Payment_Method_Code`, `Date_Payment_Made`, `Amount_Payment`) VALUES (384, 516, 'MasterCard', '2018-02-16', 241730);