yuanyuangaoup-CSDN博客

原创 sqlzoo练习3-SUM and COUNT

自做

2022-06-15 16:43:57 105 1

原创 sqlzoo练习题（3.SELECT from Nobel Tutorial）14题中，order by subject IN (‘Chemistry‘,‘Physics‘)用法解惑整理笔记

题库链接：SELECT from Nobel Tutorial - SQLZOO原题如下：14.The expression subject IN ('Chemistry','Physics') can be used as a value - it will be 0 or 1.Show the 1984 winners and subject ordered by subject and winner name; but list Chemistry and Physics last.解

2022-05-25 11:14:28 997

原创 sql练习题答案2（sqlzoo-3.SELECT from Nobel Tutorial 8-14题）

零基础学sql，sqlzoo练习题SELECT from Nobel Tutorial - SQLZOO8.Show the year, subject, and name of Physics winners for 1980 together with the Chemistry winners for 1984.select yr,subject,winner from nobelwhere (yr='1980' and subject='physics')or (yr='1984' a

2022-05-24 14:36:14 253

原创 sql练习题答案1（sqlzoo-3.SELECT from Nobel Tutorial 1-7题）

自己写的答案

2022-05-23 17:45:52 144 1

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人