Chris Baughman cmbaughman

Fixing SQL Query Performance With CTEs

SELECT
    c.customer_id,
    c.segment,
    SUM(t.amount) AS total_spent
FROM customers c

<a href="#modal">Open Modal</a>

<div id="modal" class="modal">
  <a href="#" class="close">×</a>
  <p>This is a CSS-only modal window!</p>

	/////////////////////////////////////////////////////////
	// Debounce: wait until the user stops typing
	function debounce(fn, delay) {
	let timeout;
	return (...args) => {
	clearTimeout(timeout);
	timeout = setTimeout(() => fn.apply(this, args), delay);
	};
	}

	/* Recommended font stack for neutral, modern look */
	:root { --ui-font: Inter, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, "Helvetica Neue", Arial; }

	body { font-family: var(--ui-font); }

	/* Self-hosted font (or just comment out) */
	@font-face{
	font-family: 'YourCoolFont';
	src: url('/fonts/yourcool.woff2') format('woff2');
	font-display: swap;

	html {
	scroll-behavior: smooth;
	}

	.section {
	transform: translateZ(0); /* force GPU layer */
	will-change: transform;
	}

	// Download file
	export function downloadFile(url, filename) {
	const a = document.createElement("a");
	a.href = url;
	a.download = filename;
	document.body.appendChild(a);
	a.click();
	document.body.removeChild(a);
	}
	// Example: downloadFile("/resume.pdf", "MyResume.pdf");

	@echo off
	setlocal

	:loop
	powershell -command "[void][System.Windows.Forms.Cursor]::Position = New-Object System.Drawing.Point((Get-Random -Minimum 0 -Maximum 1920), (Get-Random -Minimum 0 -Maximum 1080))"
	timeout /t 300 /nobreak >nul
	goto loop

	endlocal

	// Get connection speed
	if (navigator.connection) {
	const downlink = navigator.connection.downlink;
	console.log(`Current download speed: ${downlink} Mbps`);
	}
	else {
	console.log("Network Information API not supported");
	}

	// Mobile device vibrate

	[*]
	charset = utf-8
	end_of_line = lf
	indent_size = 2
	indent_style = space
	insert_final_newline = true
	trim_trailing_whitespace = true
	quote_type = single

	### Frontend files