visioning exercise

fromCoursewhereCNameinch('Mathematics','English') Step2SelectCid fromStudentwhereSsex='male'Step3SelectSid fromMarkwhereSidinch(STEP2) andCidinch(STEP1)Group bySid7. Find out the names of students who are evenly divided by more than the total sharing (sharing of all courses for all)Select avg from Selectfromgroupby hasavg(cmark)> (STEP1)8. Which course in Shanghai is evenly divided than FujianStep1SelectSid fromStudentwhereSnativeplace='Shanghai'Step2SelectCidavg(Cmark) fromMarkwhereSidin=(S

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

Note: 1. Some of them are self-developed, while some are post-referenced. 2. If you have any good ideas and answers, please kindly inform me or reply to them on the corresponding Exercise answers page. I hope you can point out any errors. 3. After all, I have studied advanced algebra in college and want to learn more about matrix theory (matrix = magic). I will select this book first. Chapter 1 prerequisites [Zhan Xiang matrix theory

Reproduced in this article:Chapter I.Exercise 1-1#include int main (){int a,b,c;Double D;scanf ("%d%d%d", a,b,c);D= (Double) (A+B+C);printf ("%.3lf\n", d/3.0);return 0;}Exercise 1-2#include int main (){int F;Double C;scanf ("%d", f);c=5* (F-32)/9;printf ("%.3lf\n", c);return 0;}Exercise 1-3#include int main (){int n;scanf ("%d", n);printf ("%d\n", (n (1+n))/2);return 0;}

Steps and methods of exercise (1) skillful routines and clear posture The so-called "routine" refers to the entire architecture of Taijiquan. The so-called "posture" refers to the action structure of each type. At the beginning of the school, the primary focus is on the routine proficiency, and the orientation is correct. Pay attention to the posture specification. After a period of practice, the routine has been skilled. At this time, you must focus

[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