Domain里面,15462 Computer Graphics很好玩,很推荐,但是workload不小;据Ryan O'Donnell说这两年新开的15459 Quantum Computation也可以用作domain elective,如果这样的话这门课其实不难的,不过你得喜欢理论;15455 Complexity Theory也是个经典的选择,喜欢理论喜欢251可以考虑下。 个人推荐的CS方向选课(仅供参考) 这个基本...
SELECTId,ShipCountry,CASEWHENShipCountryin('USA','Mexico','Canada')THEN'NorthAmerica'ELSE'OrtherPlace'ENDFROM'Order'WHEREId>=15445ORDERBYIdASCLIMIT20;--Result:15445|France|OrtherPlace15446|Italy|OrtherPlace15447|Portugal|OrtherPlace15448|Argentina|OrtherPlace15449|Portugal|OrtherPlace15450|Venezuela|Orthe...
sqlite>SELECTId,ShipCountry,(casewhenShipCountryin("USA","Canada","Mexico")then'NorthAmerica'else'OtherPlace'end)FROM"Order"WHEREId>=15445ORDERBYIdASCLIMIT20;15445|France|OtherPlace15446|Italy|OtherPlace15447|Portugal|OtherPlace15448|Argentina|OtherPlace15449|Portugal|OtherPlace15450|Venezuela|OtherPlace...
15459|Germany|OtherPlace 15460|Argentina|OtherPlace 15461|Austria|OtherPlace 15462|Austria|OtherPlace 15463|Finland|OtherPlace 15464|Brazil|OtherPlace 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 3...
OtherPlace15452|France|OtherPlace15453|France|OtherPlace15454|Canada|NorthAmerica15455|USA|NorthAmerica15456|France|OtherPlace15457|Mexico|NorthAmerica15458|USA|NorthAmerica15459|Germany|OtherPlace15460|Argentina|OtherPlace15461|Austria|OtherPlace15462|Austria|OtherPlace15463|Finland|OtherPlace15464|Brazil|Other...