onegrx

21:31 Your Question: I got GitHub Student Developer Pack and active @edu email. Can I register a free .me domain on your website even
though I do not live in US/UK/CAN/AUS?
21:31 Please wait, an operator will be with you shortly.
21:32 You are now chatting with Eugenia K. ­ Domains Support
21:32 Eugenia K.: Hello! Thank you for contacting our Live Chat Support!
21:32 Eugenia K.: You can grab your free .me domain only on condition that you claim it through Github student pack
21:33 Bartłomiej Szałach: Yes, I do claim it throug GH.
21:33 Bartłomiej Szałach: But before order I was asked to give my adress and only those countries were available
21:33 Bartłomiej Szałach: Should I fill the form random data?
21:34 Bartłomiej Szałach: Or have I done something wrong way?

onegrx

use northwind

select productid, sum(quantity) as totalquan
from [Order Details]
group by productid
having sum(quantity)>1200

select orderid, count(*)
from [Order Details]
group by OrderID

onegrx

use library

select fine_paid, in_date, member_no, datediff(day, due_date, in_date) as time_delay
from title inner join loanhist on title.title_no = loanhist.title_no
where title = 'Tao Teh King' and in_date > due_date

select isbn
from reservation inner join member on reservation.member_no = member.member_no
where firstname = 'Stephen' and middleinitial = 'A' and lastname = 'Graff' 

onegrx

use joindb

select buyer_name, qty
from Buyers
cross join sales

select  buyer_name, prod_name, qty
from buyers
inner join sales on buyers.buyer_id = sales.buyer_id
inner join produce on sales.prod_id = produce.prod_id

onegrx

/*
  Before running, install express by running

  npm install express
  
  and run with:
  
  node absurd_rest_service.js

  in this script's directory.

onegrx

use Northwind

select distinct E.FirstName, E.LastName, Self.ReportsTo, Other.FirstName + ' ' + Other.LastName as boss
from Employees as E 
inner join Employees as Self on E.EmployeeID = Self.ReportsTo
inner join Employees as Other on Self.EmployeeID = Other.EmployeeID

select E.FirstName, E.LastName
from Employees as E 
left outer join Employees as Self on E.EmployeeID = Self.ReportsTo

onegrx

--cw koncowe podzapytania


--2.2
select UnitPrice, ProductName
from Products
where UnitPrice < (
	select avg(UnitPrice) 
	from Products)

onegrx

/usr/lib/jvm/java-8-oracle/bin/java -Xms512M -Xmx1024M -Xss1M -XX:+CMSClassUnloadingEnabled -XX:MaxPermSize=256M -Didea.launcher.port=7534 -Didea.launcher.bin.path=/opt/idea/bin -Dfile.encoding=UTF-8 -classpath /home/onegrx/.IntelliJIdea14/config/plugins/Scala/launcher/sbt-launch.jar:/opt/idea/lib/idea_rt.jar com.intellij.rt.execution.application.AppMain xsbt.boot.Boot run
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256M; support was removed in 8.0
[info] Loading project definition from /home/onegrx/Desktop/if-tms/project
[debug] 
[debug] Initial source changes: 
[debug] 	removed:Set()
[debug] 	added: Set()
[debug] 	modified: Set()
[debug] Removed products: Set()
[debug] External API changes: API Changes: Set()

onegrx

Each of these commands will run an ad hoc http static server in your current (or specified) directory, available at http://localhost:8000. Use this power wisely.

Discussion on reddit.

Python 2.x

$ python -m SimpleHTTPServer 8000

onegrx

/usr/bin/python3.4 /home/onegrx/Desktop/db-gen/fill.py
***** Filling Company table *****
AddCompany Apple, 4734055861, apple74, apple@app.com, 984128813, Hazy Blossom Quay, Marseille, 15951, France
AddCompany Toshiba, 9278427662, toshib74, toshi@tos.com, 388570351, Harvest Meadow, Bordeaux, 46514, France
AddCompany IBM, 3039385429, ibm95, ibm@ibm.com, 597090680, Red Pigeon Park, Vancouver, 59414, Canada
AddCompany Dell, 1383345216, dell33, dell@del.com, 660358494, Crimson Otter Square, Liverpool, 58819, Great Britain
AddCompany Apple, 2717787716, apple78, apple@app.com, 212006489, Zephyr Bend, Frankfurt, 29295, Germany
AddCompany Sony, 9104934754, sony49, sony@son.com, 919905446, Big Maple Field, Hamburg, 84584, Germany
AddCompany Amazon, 7864769011, amazon07, amazo@ama.com, 932509132, Quaint Castle Summit, Paris, 51992, France
AddCompany Microsoft, 7901174665, micros12, micro@mic.com, 785852031, Jagged Lamb Park, Glasgow, 72029, Great Britain