http://sqlzoo.net/w/index.php?title=Dressmaker_hard&feed=atom&action=historyDressmaker hard - Revision history2013-05-24T13:49:46ZRevision history for this page on the wikiMediaWiki 1.20.4http://sqlzoo.net/w/index.php?title=Dressmaker_hard&diff=1926&oldid=prevConnor: Created page with "<h1>Dressmaker database: hard questions</h1> <p>You may need to create views to complete these questions - but you do not have permission to create tables or views in the defa..."2012-07-19T14:30:33Z<p>Created page with "<h1>Dressmaker database: hard questions</h1> <p>You may need to create views to complete these questions - but you do not have permission to create tables or views in the defa..."</p>
<p><b>New page</b></p><div><h1>Dressmaker database: hard questions</h1><br />
<p>You may need to create views to complete these questions - but you do not have permission to create tables or views in the default schema.<br />
Your SQL commands are executed by user scott in schema gisq - you may create or drop views and tables in schema scott but not in gisq.</p><br />
<br />
<div class='qu'><br />
When creating a view in scott you must specify the schema name of the sources and the destination. <br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
It is decided to review the materials stock. How much did each material contribute to turnover in 2002? <br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
An order for shorts has just been placed and the work is to be distributed amongst the workforce, and we wish to know how busy the shorts makers are. <br />
For each of the workers who have experience of making shorts show the number of hours work that she is currently committed to, assuming a meagre wage of £4.50 per hour <br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
"Big spender of the year" is the customer who spends the most on high value items. <br />
Identify the "Big spender of the year 2002" if the "high value" threshold is set at £30. <br />
Also who would it be if the threshold was £20 or £50? <br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<div class='qu'><br />
Who is the fastest at making trousers? <br />
<source lang='sql' class='def'><br />
</source><br />
</div><br />
<br />
<br />
<div class='qu'><br />
"Employee of the month" is the seamstress who completes the greatest value of clothes. <br />
Show the "employees of the month" for months in 2002. <br />
<source lang='sql' class='def'><br />
</source><br />
</div></div>Connor