<?xml version="1.0" encoding="UTF-8"?><sqlb_project><db path="C:/Users/jc/Downloads/recette.db" readonly="0" foreign_keys="1" case_sensitive_like="0" temp_store="0" wal_autocheckpoint="1000" synchronous="2"/><attached/><window><main_tabs open="structure browser pragmas query" current="3"/></window><tab_structure><column_width id="0" width="300"/><column_width id="1" width="0"/><column_width id="2" width="125"/><column_width id="3" width="1756"/><column_width id="4" width="0"/><expanded_item id="0" parent="1"/><expanded_item id="1" parent="1"/><expanded_item id="2" parent="1"/><expanded_item id="3" parent="1"/></tab_structure><tab_browse><current_table name="4,10:mainCuisiniers"/><default_encoding codec=""/><browse_table_settings><table schema="main" name="Cuisiniers" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_"><sort/><column_widths><column index="1" value="109"/><column index="2" value="146"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="cuisiniers" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_"><sort/><column_widths><column index="1" value="109"/><column index="2" value="146"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table><table schema="main" name="recettes" show_row_id="0" encoding="" plot_x_axis="" unlock_view_pk="_rowid_"><sort/><column_widths><column index="1" value="97"/><column index="2" value="134"/><column index="3" value="109"/><column index="4" value="87"/></column_widths><filter_values/><conditional_formats/><row_id_formats/><display_formats/><hidden_columns/><plot_y_axes/><global_filter/></table></browse_table_settings></tab_browse><tab_sql><sql name="SQL 1">SELECT * FROM Recettes ORDER BY difficulte DESC LIMIT 3;</sql><sql name="SQL 2">SELECT
	Cuisiniers.nom AS cuisinier, 
	Recettes.nom AS recette 
FROM
	Cuisiniers JOIN
	Recettes USING(id_cuisinier)
WHERE
	cuisinier = 'Gérard Mancuit';</sql><sql name="SQL 3">SELECT
	Recettes.nom AS recette,
	difficulte,
	Ingredients.nom AS ingredient,
	calories
FROM 
	Recettes 
	JOIN RecettesIngredients USING(id_recette)
	JOIN Ingredients USING(id_ingredient)
ORDER BY Recettes.nom;</sql><current_tab id="0"/></tab_sql></sqlb_project>
