Alternatives to Fast Fashion

SQL

Create table

        CREATE TABLE tblFastFashionCompanies(
            pmkFastFashionCompaniesId INT AUTO_INCREMENT PRIMARY KEY,
            fldCompany VARCHAR(20),
            fldOrigin VARCHAR(30),
            fldWages VARCHAR(20),
            fldStoreQuantity VARCHAR(20)
        )
    

Insert Data

    INSERT INTO tblFastFashionCompanies
    (fldCompany, fldOrigin, fldWages, fldStoreQuantity) VALUES
    ('Zara','Spain','No',540),
    ('Forever 21','America','No',2200),
    ('H&M','Sweden','No',3500)
    

Select Records

    SELECT fldCompany, fldOrigin, fldWages, fldStoreQuantity FROM tblFastFashionCompanies