-- Select all products with their category names SELECT p.pavadinimas AS Preke, p.kaina, k.pavadinimas AS Kategorija FROM prekes p LEFT JOIN kategorijos k ON p.kategorija_id = k.id; -- Find products with low stock (less than 10) SELECT * FROM prekes WHERE kiekis < 10; Use code with caution. Copied to clipboard Best Practices for Your SQL Draft
To draft a complete duombaze.sql (Lithuanian for "database.sql"), a well-structured file should include the core elements for initializing a database: schema creation, table definitions with appropriate data types and constraints, and sample data for testing. Duombaze.sql
This section ensures the database exists and that you are working within the correct context. -- Select all products with their category names SELECT p