Project information
- Category: SQL Project
- Title: SQL 3
- Project URL:
Description
This SQL code contains queries to extract, filter, and count data from tables related to food data sources (data_src), food descriptions (food_des), nutrition definitions (nutr_def), and food weight (weight). The queries search for specific criteria such as journal names, manufacturers, publication years, and nutrition units. Some queries count records that meet certain conditions, like data after the year 2000 or specific nutrition factors. Logical operators (AND, OR, IN, BETWEEN) are used to refine the data selection based on year ranges or journal lists.