SQL Server :: Name From Table A ,minimum Rate1 And Rate2 Values For A Month In A Dropdownlist From Date Field From Table B?

I need to write a query to populate a gridview with minimum rates in ascending order for a month from three tables.For example i have three tables A,B,C as follows

TABLE A TABLE B
TABLE C
Id id id
Quote_no Quote_no Quote_ no
Name Rate1 Equip_name
Rate2 E_rate
Date R1_rate
R2_rate
Date

Now if the data is as follows

I need to get the Name from Table A ,minimum Rate1 and Rate2 values for a month in a dropdownlist from date field from Table B and the corresponding minimum rate(E_rate) for Equipment E1 and E2 only from Table C for the month in ascending order group by Name.

TABLE A

id
Quote_no
Name
1
101
XYZ

2
102
ABC
TABLE B
id
Quote_no
Rate1
Rate2
Date

1
101
105
200
12/11/2010

2
102
90
210
15/11/2010

TABLE C
id
Quote_no
Equip_name
E_rate
R1_rate
R2_Rate
Date

1
101
E1
60
0
0
12/11/2010

1
101
R1
0
110
0
12/11/2010

1
101
E2
80
0
0
12/11/2010

2
102
R2
0
0
300
15/11/2010

2
102
E2
100
0
0
15/11/2010

2
102
R1
0
60
0
15/11/2010

2
102
E1
230
0
0
15/11/2010