wii exercise

of the school number, name;Select S.id from student s where s.id not in (select S.id from student S, Teacher T, Course C, SC where sc.s_id=s.id an D sc.c_id=c.id and C.t_id=t.id and C.id =1)6. The inquiry has studied "001" and has also learned the number and name of the students in the "002" course;Select Aa.id,aa.sname from (select S.id,s.sname from student S, Teacher T, Course C, SC where Sc.s_id=s.id and Sc.c_id=c. ID and C.t_id=t.id and c.id =1) AA, (select S.id,s.sname from student S, Teac

department number and descending by salary:SELECTEmpno,deptno,sal,ename,job fromEmpORDER by 2 ASC,3 DESC; Replace letter stringSELECTTRANSLATE ('AB Hello BCADEFG','ABCDEFG','1234567') asNew_str fromDUAL; Sort alphabetically by letter and number in a mixed column data:6767adams→ename:adamsSELECTData,translate (data,'-0123456789','-') asEname fromVORDER by 2: First, the column of letters, that is, to take out the sort of the basis of another column ename, and then in the sort, the numbers an

Label:11. Check the average score of each course.12. Check the average score of the course with at least 5 students enrolled in the score table and begin with 3.14. Sname, CNO and degree columns for all students are queried.15. Check the SNO, CNAME and degree columns of all students.16. Check the sname, CNAME and degree columns of all students.17. Check the average score of "95033" class students.19, the query elective "3-105" course performance is higher than the "109" student scores of all the

#!/bin/bashremote_ip=$1if[!-N" $"] ; Then Echo "Please usage./without_password remote_host!"Exit1Else Echo "The remote_host you input is $remote _ip"fiSSH[Email protected] $remote _IP"mkdir. ssh; chmod. SSH"Ssh-keygen-t RSASCP~/.SSH/id_rsa.pub [email protected]10.0.0.223:/root/.SSH/Authorized_keysSSH[Email protected]$1 "chmod ~/.ssh/authorized_keys"SSH[Email protected]$1ifconfigExit remote[[Email protected] ~]# exitlogoutconnection to10.0.0.223closed.eth0 Link encap:ethernet HWaddrxx: 0C:

Recently, I was going to review the shell, just to see the shell operation, and to write a simple 99 multiplication table like a beginner. It is suggested that you can run shell scripts directly in Http://www.runoob.com/try/runcode.php?filename=helloworldtype=bash if you do not want to install Linux environments.First, the previous code#!/bin/bash#使用while循环I=1;While [$i-le 9];d o #-le means less than or equal toJ=1;While [$j-le $i];d oEcho-n ${j} "x" $[i] "=" ' Expr $i \* $j ' ""; #echo-n means

ifMulti-branch statement practice#!/bin/bashread-p " Please enter 100 m running seconds: "IIf [$i-lt] [$i-GT 0]Thenecho " Enter the final "read-p " enter male and female "aif [$a = male]Thenecho " into the men's group "elif [$a = female]Thenecho " Enter the women's group "Elseecho "Error"Fielif [$i-ge 10]; Thenecho " elimination "Elseecho " Error "Fi Case Statement Practice, automatically unzip the compressed file according to the filename suffixVim untar.sh#!/bin/bashCase $ in*.gz)If [-F $]Th

/bakdir/root/dir1/dir3/file3-rw-r--r--1 root root 23M Feb 12 12:1 9/tmp/bakdir/root/dir1/file1-1-rwxr-xr-x 1 root root 3.7M Feb 12:19/tmp/bakdir/root/nginx-1.12.2/objs/ nginx-rw-r--r--1 root root 2.0M Feb 12:19/tmp/bakdir/root/pcre-8.40.tar.gz-rw-r--r--1 root root 1.2M Feb 12:19/t Mp/bakdir/root/pi. DAT 4.3 Concrete implementations[[emailprotected] ~]# cat CpFiles.sh #!/bin/bash#Func:cp files include directory#Author:reed. /etc/profileSourcePath="/root"DestPath="/tmp/BakDir"#mkdir backup direct

There is no excuse. We don't want to hear you don't have time to exercise. Or it is inconvenient for you to regularly go to the gym. Or you think it is more advantageous to spend membership dues somewhere else. If you think so, well, we have a work und here to solve all the above excuses.First, you can exercise without leaving the house. With membership dues, you can buy basic equipment that creates a bette

The nightingale rose diagram is amazing in conventional charts, but I didn't understand it at the beginning. It turns out that nightingale is so great and really worthy of respect. After carefully studying the structure of the image, we found that the original bar chart is represented by the radius of the slice chart. Of course, there are many variants, This is just what I understand. After knowing the structure of slice, the slice angle is determined based on the number of input parameters, and

Recently in the gym exercise, the purpose is to increase muscle, found that the muscle is very difficult, exercise an hour tired and the dog, the next day will be sore muscles. Later dare not say that others big is the mind simple limbs developed, this TM also very need perseverance of good, have to overcome how many brain lazy idea!Yesterday in NetEase Open class saw a video, called "The Truth of

road, it is common to run a dozen kilometers. At first, I thought it was caused by calcium deficiency. After drinking beef bone marrow soup, I made up calcium for a while, but it didn't improve much. Later I learned that most knee pain is caused by Primary Osteoarthritis caused by the aging of the knee joint itself. The occurrence and recurrence of knee pain are also related to factors such as poor blood circulation, fatigue transition, poor posture, and cold and humid weather.ProgramBoth dev

[C language exploration tour] Part 1 Lesson 10: Exercise questions + exercises, study tours Introduction 1. Course outline 2. Part 1 Lesson 10: exercise + exercise 3. Part 2 Lesson 1: Modular programming Course outline Our courses are divided into four parts. Each part has exercise questions after completion and an

C language QQ group: 108168489 This group is a common group with a maximum of 100 people. It cannot accommodate all C language students. Please forgive me. Apply to joinBe sure to enter the "class and name](Not SpecifiedClass and name, Refuse to join), And then modify the group business card. After the course ends, [cancel the Group] (you will leave the group ). [1] C LanguageProgramDesign course calendar 2010 Spring http://www.cnblogs.com/emanlee/archive/2010/04/11/1709439.html[2] C la

In our orthopedic outpatient department most common is the lumbago patient, causes the low back pain The reason many, also is more complex, therefore has the proverb "The patient lumbago, the doctor headache" one said. In fact, a large part of the symptoms of low back pain are related to muscle fascia strain or aseptic inflammation in the rear of the waist, do not need surgery, take conservative treatment can be. And one of the important things is to exercis