In this query weâve used quota_cte twice, but we only had to define it once, in the WITH clause! The alias âaâ represents the âcurrentâ QuotaDate, and the alias âbâ is the next in chronological order (if any). You can define multiple common table expressions in one WITH clause, separated by commas.
Follow this tip: Start by putting the eggs in a saucepan, covering them with cold water, and bringing it to a boil. Then, remove the pan from the heat, cover it, and let it sit for 10 minutes for firm yet creamy hard-boiled eggs, or up to 15 minutes for very firm eggs. How To Boil Eggs Perfectly Every Time.
Lower your eggs straight from the fridge into already-boiling water, or place them in a steamer insert in a covered pot steaming at full blast on the stovetop. If boiling, lower the heat to the barest simmer. Cook the eggs for 11 minutes for hard or 6 minutes for soft. Serve. Or, if serving cold, shock them in ice water immediately. Let them chill in that water for at least 15 minutes, or better yet, in the fridge overnight. Peel under cool running water.