Task: NL2SQL (source dataset: bird)

Natural language to SQL, also known as NL2SQL, is the problem of generating a SQL query that can be executed on a input table, for a given natural language question.

You will be given an input table called "table" in the markdown format, as well as a question. Your task is to generate an SQL query that can be executed on the input table to answer the question.

Please ensure that the generated SQL only return relevant columns being specifically asked in the question (e.g., in SQL please don't return more than one columns in SELECT if only one column is needed to answer the given question, and similarly please refrain from using SELECT * unless the entire row is needed to answer the question).
 
When generating SQL code, please use the SQLite syntax to ensure that your SQL is executable on SQLite3. Use only columns that are present in the table, always use quotes around your column and table names (some column names have punctuation or special characters), and refer to the columns using the column-names exactly as they appear in the table, do not add or remove punctuation (underscore, slash, etc.)

No explanation, return the code only with the following markdown codeblock format : ```sql<SQL CODE>```. For example, ```sql
SELECT * FROM "table"
``` is a valid format.

Database:
student_club

Tables:

Table: event
| event_id          | event_name                 | event_date          | type          | notes                                                         | location                       | status   |
|:------------------|:---------------------------|:--------------------|:--------------|:--------------------------------------------------------------|:-------------------------------|:---------|
| rec0Si5cQ4rJRVzd6 | March Meeting              | 2020-03-10T12:00:00 | Meeting       |                                                               | MU 215                         | Open     |
| rec0akZnLLpGUloLH | Officers meeting - January | 2020-01-14T09:30:00 | Meeting       |                                                               |                                | Open     |
| rec0dZPcWXF0QjNnE | Spring Elections           | 2019-11-24T09:00:00 | Election      | All active members can vote for new officers between 4pm-8pm. | MU 215                         | Open     |
| rec180D2MI4EpckHy | Officers meeting - March   | 2020-03-10T09:30:00 | Meeting       |                                                               |                                | Planning |
| rec2N69DMcrqN9PJC | Women's Soccer             | 2019-10-05T12:00:00 | Game          | Attend Women's soccer game as a group.                        | Campus Soccer/Lacrosse stadium | Closed   |
| rec2mJrCofveboaz6 | April Speaker              | 2020-04-21T12:00:00 | Guest Speaker |                                                               | MU 215                         | Planning |
| rec5XDvJLyxDsGZWc | Laugh Out Loud             | 2019-10-24T13:00:00 | Social        | Semester social event. Optional attendance.                   | 900 E. Washington St.          | Closed   |
| recAlAwtBZ0Fqbr5K | March Speaker              | 2020-03-24T12:00:00 | Guest Speaker |                                                               | MU 215                         | Open     |
| recEVTik3MlqbvLFi | October Speaker            | 2019-10-22T12:00:00 | Guest Speaker |                                                               | MU 215                         | Closed   |
| recGxVCwaLW3mDIa3 | Football game              | 2019-09-12T06:00:00 | Game          | Attend school football game as a group.                       | Campus Football stadium        | Closed   |


Table: major
| major_id          | major_name                             | department                                           | college                                     |
|:------------------|:---------------------------------------|:-----------------------------------------------------|:--------------------------------------------|
| rec06DF6vZ1CyPKpc | Outdoor Product Design and Development | School of Applied Sciences, Technology and Education | College of Agriculture and Applied Sciences |
| rec09LedkREyskCNv | Agricultural Communication             | School of Applied Sciences, Technology and Education | College of Agriculture and Applied Sciences |
| rec0Eanv576RhQllI | Fisheries and Aquatic Sciences         | Watershed Sciences Department                        | College of Natural Resources                |
| rec0xRZtkzxrg8kj2 | Finance                                | Economics and Finance Department                     | School of Business                          |
| rec1N0upiVLy5esTO | Forest Ecology and Management          | Wildland Resources Department                        | College of Natural Resources                |
| rec1SiX2nFrkbTleH | Biological Engineering                 | Biological Engineering Department                    | College of Engineering                      |
| rec2joRXA5HOSHE9a | Ornamental Horticulture Certificate    | Plants, Soils, and Climate Department                | College of Agriculture and Applied Sciences |
| rec3pZhvStMoNbVgy | Religious Studies                      | Religious Studies Program                            | College of Humanities and Social Sciences   |
| rec42NIsgijDV6aDE | Statistics                             | Mathematics and Statistics Department                | College of Science                          |
| rec6OKJlX4eg3hOLe | Journalism                             | Journalism and Communication Department              | College of Humanities and Social Sciences   |


Table: zip_code
|   zip_code | type     | city       | county              | state       | short_state   |
|-----------:|:---------|:-----------|:--------------------|:------------|:--------------|
|        501 | Unique   | Holtsville | Suffolk County      | New York    | NY            |
|        544 | Unique   | Holtsville | Suffolk County      | New York    | NY            |
|        601 | Standard | Adjuntas   | Adjuntas Municipio  | Puerto Rico | PR            |
|        602 | Standard | Aguada     | Aguada Municipio    | Puerto Rico | PR            |
|        603 | Standard | Aguadilla  | Aguadilla Municipio | Puerto Rico | PR            |
|        604 | PO Box   | Aguadilla  |                     | Puerto Rico | PR            |
|        605 | PO Box   | Aguadilla  |                     | Puerto Rico | PR            |
|        606 | Standard | Maricao    | Maricao Municipio   | Puerto Rico | PR            |
|        610 | Standard | Anasco     | Anasco Municipio    | Puerto Rico | PR            |
|        611 | PO Box   | Angeles    |                     | Puerto Rico | PR            |


Table: attendance
| link_to_event     | link_to_member    |
|:------------------|:------------------|
| rec2N69DMcrqN9PJC | recD078PnS3x2doBe |
| rec2N69DMcrqN9PJC | recP6DJPyi5donvXL |
| rec2N69DMcrqN9PJC | rec28ORZgcm1dtqBZ |
| rec2N69DMcrqN9PJC | recTjHY5xXhvkCdVT |
| rec2N69DMcrqN9PJC | recZ4PkGERzl9ziHO |
| rec2N69DMcrqN9PJC | recEFd8s6pkrTt4Pz |
| rec2N69DMcrqN9PJC | recEymrwCUKxiiosI |
| rec2N69DMcrqN9PJC | recQaxyXBQG5BBtD0 |
| rec2N69DMcrqN9PJC | recT92PyyZCGq1R68 |
| rec2N69DMcrqN9PJC | recJMazpPVexyFYTc |


Table: budget
| budget_id         | category      |   spent |   remaining |   amount | event_status   | link_to_event     |
|:------------------|:--------------|--------:|------------:|---------:|:---------------|:------------------|
| rec0QmEc3cSQFQ6V2 | Advertisement |   67.81 |        7.19 |       75 | Closed         | recI43CzsZ0Q625ma |
| rec1bG6HSft7XIvTP | Food          |  121.14 |       28.86 |      150 | Closed         | recggMW2eyCYceNcy |
| rec1z6ISJU2HdIsVm | Food          |   20.2  |       -0.2  |       20 | Closed         | recJ4Witp9tpjaugn |
| rec33PFqxLtnp80RJ | Speaker Gifts |    0    |       25    |       25 | Open           | recHaMmaKyfktt5fW |
| rec4DYUKBHMPZXWB2 | Food          |    0    |      150    |      150 | Open           | recHaMmaKyfktt5fW |
| rec4yM47hEjVVsCuq | Parking       |    0    |       10    |       10 | Open           | recs4x1BYWAsU2SKg |
| rec59vErJo51glQRb | Advertisement |    0    |       55    |       55 | Open           | recwM7GMBSLDlb1Ix |
| rec5V70sIuIgpOzDT | Food          |  173.06 |      -23.06 |      150 | Closed         | recI43CzsZ0Q625ma |
| recFZ47e0eVqcQD9O | Advertisement |    0    |       75    |       75 | Open           | recHaMmaKyfktt5fW |
| recHzdM40gk9a6AdY | Speaker Gifts |    0    |       25    |       25 | Planning       | rec2mJrCofveboaz6 |


Table: expense
| expense_id        | expense_description   | expense_date   |   cost | approved   | link_to_member    | link_to_budget    |
|:------------------|:----------------------|:---------------|-------:|:-----------|:------------------|:------------------|
| rec017x6R3hQqkLAo | Post Cards, Posters   | 2019-08-20     | 122.06 | true       | rec4BLdZHS2Blfp4v | recvKTAWAFKkVNnXQ |
| rec1nIjoZKTYayqZ6 | Water, Cookies        | 2019-10-08     |  20.2  | true       | recro8T1MPMwRadVH | recy8KY5bUdzF81vv |
| rec1oMgNFt7Y0G40x | Pizza                 | 2019-09-10     |  51.81 | true       | recD078PnS3x2doBe | recwXIiKoBMjXJsGZ |
| rec4Zg7WEmfiHXcnC | Posters               | 2019-10-10     |  67.81 | true       | rec4BLdZHS2Blfp4v | recsI0IzpUuxl2bPh |
| rec7gUiykKKW4RaJS | Parking               | 2019-11-19     |   6    | true       | recro8T1MPMwRadVH | recTUGXxhTaFZ2qkg |
| recBqNAd2axwvbSUd | Water, Cookies        | 2019-09-10     |  20.2  | true       | recro8T1MPMwRadVH | recZAjcliIUo4BCKW |
| recHPdtBtpThSA9lq | Pizza                 | 2019-10-22     |  92.82 | true       | recD078PnS3x2doBe | recr60T1tLsfdICV8 |
| recILV3eykJuWc489 | Pizza                 | 2019-11-19     |  62.6  | true       | recD078PnS3x2doBe | reczf4LoOK6z7oOec |
| recIudsuLiDpzK8Io | Posters               | 2019-09-01     |  54.25 |            | recD078PnS3x2doBe | recMc8TbR76rmUSHG |
| recJnyr7Z1CjAlHgA | Posters               | 2019-10-01     |  54.25 | true       | recD078PnS3x2doBe | recTxecmwIhCdIKvl |


Table: income
| income_id         | date_received   |   amount | source      | notes                                            | link_to_member    |
|:------------------|:----------------|---------:|:------------|:-------------------------------------------------|:------------------|
| rec0s9ZrO15zhzUeE | 2019-10-17      |       50 | Dues        |                                                  | reccW7q1KkhSKZsea |
| rec7f5XMQZexgtQJo | 2019-09-04      |       50 | Dues        |                                                  | recTjHY5xXhvkCdVT |
| rec8BUJa8GXUjiglg | 2019-10-08      |       50 | Dues        |                                                  | recUdRhbhcEO1Hk5r |
| rec8V9BPNIoewWt2z | 2019-10-02      |       50 | Dues        |                                                  | rec3pH4DxMcWHMRB7 |
| recCRWMfFqifuKMc6 | 2019-09-18      |       50 | Dues        |                                                  | rec28ORZgcm1dtqBZ |
| recMCFQxAiJXxrbsG | 2019-10-31      |       50 | Dues        |                                                  | recZN8afUWlE5fZHG |
| recMFy9sJHhuPZ4cz | 2019-09-25      |       50 | Dues        |                                                  | recjHj4BS5A541n9v |
| recN3WFwGR0c17xe2 | 2019-09-14      |      200 | Fundraising | Secured donations to help pay for speaker gifts. |                   |
| recOo362sJrXFv2az | 2019-09-25      |       50 | Dues        |                                                  | recL94zpn6Xh6kQii |
| recPG7h3YcEJpddEW | 2019-09-16      |       50 | Dues        |                                                  | recro8T1MPMwRadVH |


Table: member
| member_id         | first_name   | last_name   | email                    | position       | t_shirt_size   | phone          |   zip | link_to_major     |
|:------------------|:-------------|:------------|:-------------------------|:---------------|:---------------|:---------------|------:|:------------------|
| rec1x5zBFIqoOuPW8 | Angela       | Sanders     | angela.sanders@lpu.edu   | Member         | Medium         | (651) 928-4507 | 55108 | recxK3MHQFbR9J5uO |
| rec280Sk7o31iG0Tx | Grant        | Gilmour     | grant.gilmour@lpu.edu    | Member         | X-Large        | 403-555-1310   | 29440 | rec7BxKpjJ7bNph3O |
| rec28ORZgcm1dtqBZ | Luisa        | Guidi       | luisa.guidi@lpu.edu      | Member         | Medium         | 442-555-5882   | 10002 | recdIBgeU38UbV2sy |
| rec2a03QXbFQAUZ7X | Randy        | Woodard     | randy.woodard@lpu.edu    | Inactive       | X-Large        | 490-555-8460   |  8021 |                   |
| rec3pH4DxMcWHMRB7 | Connor       | Hilton      | connor.hilton@lpu.edu    | Member         | X-Large        | 454-555-7970   | 48236 | recaJdSK83k6ekRJL |
| rec4BLdZHS2Blfp4v | Sacha        | Harrison    | sacha.harrison@lpu.edu   | President      | Large          | 840-555-4781   |  7080 | recCk8lCDOTRp6rKN |
| rec4O9rmGnLx3j8vt | Christof     | Nielson     | christof.nielson@lpu.edu | Member         | X-Large        | (701) 932-1903 | 58102 | rectOU2QnznthfWv7 |
| rec75vvFxgYtHmqxY | Carlo        | Jacobs      | carlo.jacobs@lpu.edu     | Member         | Medium         | 928-555-2577   | 11104 | recf3mPmWq4JXKf4L |
| recD078PnS3x2doBe | Phillip      | Cullen      | phillip.cullen@lpu.edu   | Vice President | X-Large        | 905-555-5035   |  1020 | rec9CqGCGV8Y8rOSY |
| recEFd8s6pkrTt4Pz | Matthew      | Snay        | matt.snay@lpu.edu        | Member         | Large          | 260-555-4328   |  7002 | recxRBSgVYeSEGvyo |


Question: In the College of Agriculture and Applied Sciences, how many majors are under the department of School of Applied Sciences, Technology and Education?

db_id: student_club
tables: name: event
data: event.csv
name: major
data: major.csv
name: zip_code
data: zip_code.csv
name: attendance
data: attendance.csv
name: budget
data: budget.csv
name: expense
data: expense.csv
name: income
data: income.csv
name: member
data: member.csv
label: SELECT COUNT(major_id) FROM major WHERE department = 'School of Applied Sciences, Technology and Education' AND college = 'College of Agriculture and Applied Sciences'
sqlite_path: $MMTU_HOME/data_sqlite/bird/dev_20240627/dev_databases/student_club/student_club.sqlite