Holger databraineo

## sql1x1-01.sql
SELECT * FROM Artist;

## sql1x1-02.sql
SELECT
  ArtistId,
  Name
FROM Artist;

## sql1x1-03.sql
SELECT
  ArtistId,
  Name AS Kuenstler
FROM Artist;

## sql1x1-04.sql
SELECT
  ArtistId,
  Name
FROM Artist
WHERE substr(Name,1,1)='A';

## sql1x1-05.sql
SELECT
  ArtistId,
  Name
FROM Artist
WHERE Name LIKE 'A%';

## sql1x1-06.sql
SELECT
  ArtistId,
  Name
FROM Artist
WHERE Name LIKE 'A%' AND NOT Name LIKE '_c%';

## sql1x1-07.sql
SELECT *
FROM Track
ORDER BY Composer DESC, Name;

## sql1x1-08
SELECT	DISTINCT
  Composer
FROM Track
ORDER BY Composer;

## sql1x1-09.sql
SELECT
  Name,
  substr(Name,1,1) AS [Index],
  CASE WHEN Milliseconds > 300000 THEN '> 5min.' END AS Länge1,
  CASE WHEN Milliseconds > 300000 THEN '> 5min.' ELSE 'kurz' END AS Länge2
FROM Track;

## sql1x1-10.sql
SELECT
  Name,
  substr(Name,1,1) AS [Index],
  CASE WHEN Milliseconds > 360000 THEN '> 6min.'
       WHEN Milliseconds > 300000 THEN '5-6 min.'
       WHEN Milliseconds > 240000 THEN '4-5 min.'
	ELSE 'kurz'
  END AS Länge
FROM Track;
	SELECT
	ArtistId,
	Name
	FROM Artist
	WHERE Name LIKE 'A%' AND NOT Name LIKE '_c%';
	SELECT
	Name,
	substr(Name,1,1) AS [Index],
	CASE WHEN Milliseconds > 300000 THEN '> 5min.' END AS Länge1,
	CASE WHEN Milliseconds > 300000 THEN '> 5min.' ELSE 'kurz' END AS Länge2
	FROM Track;